Oracle | DBMS_JSON

Oracle DBMS_JSON_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Internal JSON support utilities

AUTHID CURRENT_USER

Dependencies

DBMS_JSON

DBMS_JSON_LIB

Documented No

First Available 12.2

Security Model Owned by XDB with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtjson.plb

Subprograms

ADDVC	CREATEVIEWONPATH	GETDATAGUIDE
BLOB2JSON	DROPVC	PJCOLINM
CHECKPRIVILEGE	GENDATAGUIDE	RENAME

ADDVC

Add a virtual column dbms_json_int.addVC( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, indexname IN VARCHAR2, frequency IN NUMBER, hidden IN BOOLEAN);

CREATE TABLE j_purchase_order(

      doc_id      RAW (16) NOT NULL,

      date_loaded TIMESTAMP(6) WITH TIME ZONE,

      po_document CLOB);

      

      SELECT DISTINCT defer, condition

      FROM cdef$;

      

      ALTER TABLE j_purchase_order

      ADD CONSTRAINT ensure_json

      CHECK (po_document IS JSON);

      

      exec xdb.dbms_json_int.addVC(USER, 'J_PURCHASE_ORDER', 'po_document', NULL, NULL, TRUE);

BLOB2JSON (new 21c)

See DBMS_JSON.

Protected by an ACCESSIBLE BY clause dbms_json_int.blob2json( owner IN VARCHAR2, tablename IN VARCHAR2, columnname IN VARCHAR2, throwerror IN BOOLEAN);

See DBMS_JSON.BLOB_TO_JSON

CHECKPRIVILEGE

Undocumented dbms_json_int.checkPrivilege( uname IN VARCHAR2, owner IN VARCHAR2, tablename IN VARCHAR2);

TBD

CREATEVIEWONPATH

Undocumented dbms_json_int.createViewOnPath( owner IN VARCHAR2, viewname IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, path IN VARCHAR2, indexname IN VARCHAR2, frequency IN NUMBER, resourcepath IN VARCHAR2, materialize IN BOOLEAN);

TBD

DROPVC

Drop a virtual column dbms_json_int.dropVC( owner IN VARCHAR2, tablename IN VARCHAR2, jcolname IN VARCHAR2, indexname IN VARCHAR2);

TBD

GENDATAGUIDE

dbms_json_int.genDataGuide( dgtabname IN VARCHAR2, tabviewname IN VARCHAR2, jcolname IN VARCHAR2, estimate_percent IN NUMBER);

TBD

GETDATAGUIDE

dbms_json_int.getDataGuide( owner IN VARCHAR2, indexname IN VARCHAR2, format IN NUMBER, dataguide IN OUT CLOB);

TBD

PJCOLINM

dbms_json_int.pjcolinm( owner IN VARCHAR2, tabname IN VARCHAR2, jcolname IN VARCHAR2, format IN VARCHAR2);

TBD

RENAME

dbms_json_int.rename( indexname IN VARCHAR2, path IN VARCHAR2, type IN NUMBER, preferred_name IN VARCHAR2);

TBD