Index

C  D  E  F  G  H  I  L  M  N  O  P  R  S  T  W  

---

C

• chaining together SODA_OPERATION_T methods 3.9
• collection configuration 4
• collection metadata
  • custom 4.2
  • getting 4.1
• collections
  • checking existence 3.4
  • creating 3.2
    • with custom metadata 4.2
  • discovering 3.5
  • dropping 3.6
  • opening 3.3
    • during creation 3.2
• committing a transaction 3.15
• components of SODA documents 3.7
• create_collection function
  • transaction handling 3.15
• creating collections 3.2
  • with custom metadata 4.2
• creating documents 3.7

---

D

• database role SODA_APP 3.1
• DBMS_SODA.DOC_BLOB constant 3.7
• DBMS_SODA.DOC_CLOB constant 3.7
• DBMS_SODA.DOC_VARCHAR2 constant 3.7
• DBMS_SODA package subprograms
  • create_collection
    • example 3.2
    • transaction handling 3.15
  • drop_collection
    • example 3.6
    • transaction handling 3.15
  • list_collection_names
    • example 3.5
  • open_collection
    • example 3.3, 3.4
• deleting collections
  • See: dropping collections
• deleting documents from collections
  • See: removing documents from collections
• discovering collections
  • checking existence 3.4
  • listing 3.5
• documents
  • components 3.7
  • creating 3.7
  • finding in collections 3.10
  • inserting into collections 3.8
  • metadata 3.7
  • removing from collections 3.12
  • replacing in collections 3.11
• drop_collection function
  • example 3.6
  • transaction handling 3.15
• dropping collections 3.6

---

E

• existing collection, checking for 3.4

---

F

• filter() SODA_COLLECTION_T method 3.10
• find() SODA_COLLECTION_T method 3.10
• finding documents in collections 3.10

---

G

• get_blob() SODA_DOCUMENT_T method 3.7
• get_clob() SODA_DOCUMENT_T method 3.7
• get_created_on() SODA_DOCUMENT_T method 3.7
• get_cursor() SODA_COLLECTION_T method 3.10
• get_data_type() SODA_DOCUMENT_T method 3.7
• get_key() SODA_DOCUMENT_T method 3.7
• get_last_modified() SODA_DOCUMENT_T method 3.7
• get_media_type() SODA_DOCUMENT_T method 3.7
• get_metadata() SODA_COLLECTION_T method 4.1
• get_one() SODA_COLLECTION_T method 3.10
• get_varchar2() SODA_DOCUMENT_T method 3.7
• get_version() SODA_DOCUMENT_T method 3.7
• getter methods, document 3.7
• getting collection metadata 4.1
• getting document components 3.7

---

H

• handling transactions 3.15

---

I

• insert_one_and_get() SODA_COLLECTION_T method 3.8
• insert_one() SODA_COLLECTION_T method 3.8
• inserting documents into collections 3.8

---

L

• list_collection_names function
  • example 3.5
• listing collections 3.5

---

M

• metadata of collections
  • getting 4.1
• metadata of documents
  • getting 3.7

---

N

• nonterminal SODA methods, definition 3.9

---

O

• open_collection function
  • example 3.3
• opening collections 3.3
  • during creation 3.2

---

P

• prerequisites for using SODA for PL/SQL 1

---

R

• read and write operations 3.9
• remove() SODA_OPERATION_T method 3.12
• removing documents from collections 3.12
• replace_one_and_get() SODA_OPERATION_T method 3.11
• replace_one() SODA_OPERATION_T method 3.11
• replacing documents in collections 3.11
• role SODA_APP 3.1
• rolling back a transaction 3.15

---

S

• SODA_APP database role 3.1
• SODA_COLLECTION_T methods
  • filter() 3.10
  • find() 3.10
  • get_cursor() 3.10
  • get_metadata() 4.1
  • get_one() 3.10
  • insert_one_and_get() 3.8
  • insert_one() 3.8
• SODA_DOCUMENT_T methods
  • get_blob() 3.7
  • get_clob() 3.7
  • get_created_on() 3.7
  • get_data_type() 3.7
  • get_key() 3.7
  • get_last_modified() 3.7
  • get_media_type() 3.7
  • get_varchar2() 3.7
  • get_version() 3.7
• SODA_DOCUMENT_T object type and constructors 3.7
• SODA_OPERATION_T methods 3.9
  • remove() 3.12
  • replace_one_and_get() 3.11
  • replace_one() 3.11

---

T

• terminal SODA methods, definition 3.9
• transaction handling 3.15

---

W

• write and read operations 3.9