Index

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

---

A

• acquire_lock() SODA_OPERATION_T method 3.12
• as_of_scn() SODA_OPERATION_T method 3.11
• as_of_timestamp() SODA_OPERATION_T method 3.11

---

C

• chaining together SODA_OPERATION_T methods 3.10
• collection configuration 4
• collection metadata
  • custom 4, 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
  • truncating 3.14
• committing a transaction 3.18
• components of SODA documents 3.7
• count() SODA_OPERATION_T method 3.11
• create_collection function
  • transaction handling 3.18
• create_index() SODA_COLLECTION_T method 3.15
• creating collections 3.2
  • with custom metadata 4.2
• creating documents 3.7

---

D

• database role SODA_APP 3.1
• data guide
  • creating relational view from 3.17
  • getting for a collection 3.16
• 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.18
  • drop_collection
    • example 3.6
    • transaction handling 3.18
  • 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.11
  • inserting into collections 3.8
  • metadata 3.7
  • removing from collections 3.13
  • replacing in collections 3.12
• drop_collection function
  • example 3.6
  • transaction handling 3.18
• drop_index() SODA_COLLECTION_T method 3.15
• dropping collections 3.6

---

E

• emptying a collection 3.14
• existing collection, checking for 3.4

---

F

• filter() SODA_OPERATION_T method 3.11
• find() SODA_COLLECTION_T method 3.11
• finding documents in collections 3.11
• flashback querying of collection data 3.11

---

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_OPERATION_T method 3.11
• get_data_guide() SODA_COLLECTION_T method 3.16
• get_data_guide() SODA_OPERATION_T method 3.16
• 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_OPERATION_T method 3.11
• 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.18
• hint
  • SQL monitoring 3.8, 3.9, 3.11
• hint() SODA_OPERATION_T method 3.11

---

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

---

J

• JSON data guide
  • creating relational view from 3.17
  • getting for a collection 3.16

---

L

• list_collection_names function
  • example 3.5
• listing collections 3.5
• locking documents
  • pessimistic 3.12

---

M

• metadata, custom 4
• metadata of collections
  • getting 4.1
• metadata of documents
  • getting 3.7
• MONITOR SQL hint 3.8, 3.9, 3.11

---

N

• nonterminal SODA methods, definition 3.10

---

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.10
• relational view, created from collection data guide 3.17
• remove() SODA_OPERATION_T method 3.13
• removing all documents from a collection 3.14
• removing documents from collections 3.13
• replace_one_and_get() SODA_OPERATION_T method 3.12
• replace_one() SODA_OPERATION_T method 3.12
• replacing documents in collections 3.12
• role SODA_APP 3.1
• rolling back a transaction 3.18

---

S

• SODA_APP database role 3.1
• SODA_COLLECTION_T methods
  • create_index() 3.15
  • drop_index() 3.15
  • find() 3.11
  • get_data_guide() 3.16
  • get_metadata() 4.1
  • 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.10
  • acquire_lock() 3.12
  • as_of_scn() 3.11
  • as_of_timestamp() 3.11
  • count() 3.11
  • filter() 3.11
  • get_cursor() 3.11
  • get_data_guide() 3.16
  • get_one() 3.11
  • hint() 3.11
  • remove() 3.13
  • replace_one_and_get() 3.12
  • replace_one() 3.12

---

T

• terminal SODA methods, definition 3.10
• transaction handling 3.18
• truncating a collection 3.14

---

V

• view, created from collection data guide 3.17

---

W

• write and read operations 3.10