Oracle Magazine, July/August 2019
Database Developer PL SQL ORACLE MAGAZINE JULY AUGUST 2019 108 And I see this output Key Green thing grass REPLACING DOCUMENTS Suppose I want to change a document in my collection Currently I will need to replace it with another So I first create or receive the document find the document using its key and use replace_ one or replace_ one_ and_ get In the block below I use the same ColorKeys collection created in the previous section and replace the Red document with a Blue document DECLARE l_ collection SODA_ COLLECTION_ T l_ document SODA_ DOCUMENT_ T l_ new_ document SODA_ DOCUMENT_ T BEGIN l_ collection DBMS_ SODA open_ collection ColorKeys l_ document SODA_ DOCUMENT_ T b_ content utl_ raw cast_ to_ raw Blue Bluebird l_ new_ document l_ collection find key Red replace_ one_ and_ get l_ document IF l_ new_ document IS NOT NULL THEN
You must have JavaScript enabled to view digital editions.