Oracle | DBMS_JSON

Oracle DBMS_JSON_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

Direct access to some objects in this package is prevented by means of an Accessible By clause.

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