Oracle Magazine, March/April 2019
Database Developer PL SQL ORACLE MAGAZINE MARCH APRIL 2019 97 TABLE_ NAME SODACollection Each document is stored as a row in the collections table DECLARE l_ collection soda_ collection_ t l_ document soda_ document_ t BEGIN l_ collection dbms_ soda create_ collection MyFriends l_ document l_ collection insert_ one_ and_ get soda_ document_ t b_ content UTL_ RAW cast_ to_ raw friend_ type 3 friend_ name Helen END SELECT id UTF8 Encoded JSON String FROM MyFriends UTF8 Encoded JSON String 50D58CF995704F70BFED14673D482A95
You must have JavaScript enabled to view digital editions.