Oracle DBMS_JSON_INT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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