Oracle DBMS_JSON_INT
Version 18.3

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.0.1
Security Model Owned by XDB with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtjson.plb
Subprograms
 
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);
 
CREATEVIEWONPATH
  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

Related Topics
Built-in Functions
Built-in Packages
DBMS_JSON
DBMS_JSON0
JSON Functionality
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx