You can chain together SODA_OPERATION_T replace-operation method replace_one() or replace_one_and_get() with nonterminal method key() to uniquely identify a document to be replaced.
Replacing Documents in a Collection with SODA for PL/SQL. You can use nonterminal methods, such as key(), keys(), and filter(), to specify conditions for a find operation. You can use terminal method count() to count the documents in a collection. You can use SODA_OPERATION_T terminal method get_one() or get_cursor() to find one or multiple documents in a collection, respectively. Finding Documents in Collections with SODA for PL/SQL. You can chain together SODA_OPERATION_T methods, to specify read and write operations against a collection. SODA for PLSQL Read and Write OperationsĪ SODA_OPERATION_T instance is returned by method find() of SODA_COLLECTION_T. These methods create document keys automatically, unless the collection is configured with client-assigned keys and the input document provides the key. To insert a document into a collection, you invoke SODA_COLLECTION_T method (member function) insert_one() or insert_one_and_get(). Inserting Documents into Collections with SODA for PL/SQL. You use a constructor for PL/SQL object type SODA_DOCUMENT_T to create SODA documents. Creating Documents with SODA for PL/SQL. You use PL/SQL function DBMS_SODA.drop_collection to drop a document collection. Dropping a Document Collection with SODA for PL/SQL. You can use PL/SQL function DBMS_SODA.list_collection_names to discover existing collections. Discovering Existing Collections with SODA for PL/SQL. 
It returns a SQL NULL value if a collection with the specified name does not exist otherwise, it returns the collection object. You can use PL/SQL function DBMS_SODA.open_collection to check for the existence of a given collection.
Checking Whether a Given Collection Exists with SODA for PL/SQL. You can use PL/SQL function DBMS_SODA.open_collection to open an existing document collection. Opening an Existing Document Collection with SODA for PL/SQL. You can use PL/SQL function DBMS_SODA.create_collection to create a document collection with the default metadata. Creating a Document Collection with SODA for PL/SQL. How to access SODA for PL/SQL is described, as well as how to use it to create a database collection, insert a document into a collection, and retrieve a document from a collection.
0 kommentar(er)
