Oracle Magazine, July/August 2019
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2019 103 Document key BE2CA098F5554F5DBFF9454A8F02DEA4 Content friend_ type 2 friend_ name Jorge favorites color green flavor chocolate tree oak I can also use the query by example syntax to search for documents whose nested array elements match a certain criterion The code below finds and displays all friends whose favorite flavor is chocolate DECLARE l_ document soda_ document_ t l_ cursor soda_ cursor_ t
You must have JavaScript enabled to view digital editions.