Oracle Magazine, July/August 2019
Database Developer PL SQL DBMS_ OUTPUT put_ line Document DBMS_ OUTPUT put_ line Key l_ new_ document get_ key ORACLE MAGAZINE JULY AUGUST 2019 109 END IF COMMIT END If I do not need the result document the document returned by and_ get methods I can call the replace_ one method That replaces the specified document and returns a status value 1 if the document was replaced 0 otherwise REMOVING DOCUMENTS My previous article on SODA showed you how to remove a single document You can now use a remove method in SODA_ OPERATION_ T to remove one or many documents once you have found via key or filter the document or documents you wish to remove Here is an example of single document removal DECLARE l_ collection SODA_ COLLECTION_ T l_ status NUMBER BEGIN l_ collection DBMS_ SODA open_ collection ColorKeys l_ status l_ collection find key Green remove IF l_ status 1
You must have JavaScript enabled to view digital editions.