Oracle DBMS_JSON_INT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose  
AUTHID CURRENT_USER
Dependencies
DBMS_JSON DBMS_JSON_LIB  
Documented No
Exceptions
Error Code Reason
   
   
   
First Available 12.2.0.1
Security Model Owned by XDB with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtjson.plb
Subprograms
ADDVC GENDATAGUIDE PJCOLINM
CREATEVIEWONPATH GETDATAGUIDE RENAME
DROPVC    
 
ADDVC (new 12.2)
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 (new 12.2)
  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 (new 12.2)
Drop a virtual column dbms_json_int.dropVC(
owner     IN VARCHAR2,
tablename IN VARCHAR2,
jcolname  IN VARCHAR2,
indexname IN VARCHAR2);
 
 
GENDATAGUIDE (new 12.2)
  dbms_json_int.genDataGuide(
dgtabname        IN VARCHAR2,
tabviewname      IN VARCHAR2,
jcolname         IN VARCHAR2,
estimate_percent IN NUMBER);
 
 
GETDATAGUIDE (new 12.2)
  dbms_json_int.getDataGuide(
owner     IN     VARCHAR2,
indexname IN     VARCHAR2,
format    IN     NUMBER,
dataguide IN OUT CLOB);
 
 
PJCOLINM (new 12.2)
  dbms_json_int.pjcolinm(
owner    IN VARCHAR2,
tabname  IN VARCHAR2,
jcolname IN VARCHAR2,
format   IN VARCHAR2);
 
 
RENAME (new 12.2)
  dbms_json_int.rename(
indexname      IN VARCHAR2,
path           IN VARCHAR2,
type           IN NUMBER,
preferred_name IN VARCHAR2);
 

Related Topics
Built-in Functions
Built-in Packages
DBMS_JSON
DBMS_JSON0
JSON Functionality
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved