Oracle Magazine, March/April 2019
Database Developer PL SQL ORACLE MAGAZINE MARCH APRIL 2019 95 l_ replaced_ document soda_ document_ t BEGIN l_ collection dbms_ soda create_ collection MyFriends2 l_ original_ document l_ collection insert_ one_ and_ get soda_ document_ t b_ content UTL_ RAW cast_ to_ raw friend_ type 3 friend_ name Helen Show the content l_ original_ document l_ collection find_ one l_ original_ document get_ key DBMS_ OUTPUT put_ line Original content UTL_ RAW cast_ to_ varchar2 l_ original_ document get_ blob Create a document not inserted into any collection with the corrected name Helena l_ new_ document soda_ document_ t b_ content UTL_ RAW cast_ to_ raw friend_ type 3 friend_ name Helena Replace the original document and verify the contents
You must have JavaScript enabled to view digital editions.