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.
Do you remember when mainframes were replaced by client-server? When
client-server was replaced by n-tier architecture? The "Cloud" is a
distraction ... DevOps is not. Prepare for the future.
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));