Oracle DBMS_JSON_INT
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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 18cR3
What's New In 19cR3

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