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
    • redefining A
  • collection configuration 4
  • collection metadata
  • collections
    • checking existence 3.4
    • creating 3.2
      • with custom metadata 4.2
    • discovering 3.5
    • dropping 3.6
    • heterogeneous, full-text searching 3.11
    • 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
    • open_collection
  • 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
  • full-text search of non-JSON documents 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_index() SODA_COLLECTION_T method 3.15
  • 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
  • heterogeneous collection, full-text search 3.11
  • hint
  • hint() SODA_OPERATION_T method 3.11

I

  • indexes, getting 3.15
  • indexing a collection 3.15
  • 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
  • list_indexes() SODA_COLLECTION_T method 3.15
  • listing collections 3.5
  • locking documents

M

  • metadata, custom 4, 4.2
  • metadata of collections
  • metadata of documents
  • MONITOR SQL hint 3.8, 3.9, 3.11

N

  • nonterminal SODA methods, definition 3.10

O

  • open_collection function
  • opening collections 3.3
    • during creation 3.2

P

  • prerequisites for using SODA for PL/SQL 1

R

  • read and write operations 3.10
  • redefining a collection A
  • redefining collection metadata A
  • 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

  • sample() SODA_OPERATION_T method 3.16
  • 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_index() 3.15
    • get_metadata() 4.1
    • insert_one_and_get() 3.8
    • insert_one() 3.8
    • list_indexes() 3.15
  • 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

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