The Library is currently in the process of being upgraded from Oracle Database Version 188.8.131.52 to 184.108.40.206.
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.
Owned by SYS with no privileges granted
Undocumented - but here's the source code. Some of the slickest coding I've ever seen. <g>
This code is based on sample code found in catxdbdv.sql in the 12c Beta
FUNCTION is_schema_present(objname IN VARCHAR2, userno IN NUMBER) RETURN NUMBER AS
SELECT xml_schema_name_present.is_schema_present('Larry Ellison', 1)
This demo code was extracted from cdcore.sql and reformatted for clarity
AND 1 = (
SELECT /*+ NO_MERGE */ xml_schema_name_present.is_schema_present(o.name, u2.id2) id1
SELECT /*+ NO_MERGE */ userenv('SCHEMAID') id2
FROM dual) u2));