The Library is currently in the process of being upgraded from Oracle Database Version 22.214.171.124 to 126.96.36.199.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
The new 12.2 DBMS_JSON built-in package provides
an interface for dataguide operations for those working with Java Script
Object Notation inside the Oracle database. Be sure to also learn about
the new 12.2 function JSON_DATAGUIDE that takes as its input a table
column of JSON data and, for each JSON document in the column, returns a
flat data guide as a CLOB.
Create a view based on dataguide information, with relational columns, top level scalar types, and fully expanded subtree under a given path.
When running on the shard catalog server this raises an error stating that the dataguide is empty.
viewname IN VARCHAR2,
tablename IN VARCHAR2,
jcolname IN VARCHAR2,
path IN VARCHAR2,
frequency IN NUMBER DEFAULT 0);