Oracle Magazine, March/April 2019
Database Developer PL SQL ORACLE MAGAZINE MARCH APRIL 2019 96 l_ replaced_ document l_ collection replace_ one_ and_ get l_ original_ document get_ key l_ new_ document l_ replaced_ document l_ collection find_ one l_ replaced_ document get_ key DBMS_ OUTPUT put_ line Replaced content UTL_ RAW cast_ to_ varchar2 l_ replaced_ document get_ blob END Original content friend_ type 3 friend_ name Helen Replaced content friend_ type 3 friend_ name Helena BEHIND THE SCENES The SODA API is implemented with tables and rows When you create a collection a table of the same name is created with the case preserved DECLARE l_ collection soda_ collection_ t BEGIN l_ collection dbms_ soda create_ collection SODACollection END SELECT table_ name FROM USER_ TABLES WHERE table_ name like SODA
You must have JavaScript enabled to view digital editions.