Oracle XML_SCHEMA_NAME_PRESENT
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. 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.
Purpose Undocumented
AUTHID DEFINER
Dependencies
ALL_ANNOTATION_TEXT_METADATA ALL_REPGENERATED APEX_SYS_ALL_OBJECTS
ALL_OBJECTS ALL_REPGENOBJECTS DV$OUT
ALL_OBJECTS_AE ALL_REPGROUPED_COLUMN XML_SCHEMA_NAME_PRESENT
ALL_PROBE_OBJECTS ALL_REPKEY_COLUMNS _ALL_REPCOLUMN
ALL_PROCEDURES ALL_REPOBJECT _ALL_REPCOLUMN_GROUP
ALL_REPCATLOG ALL_REPPARAMETER_COLUMN _ALL_REPCONFLICT
ALL_REPCOLUMN ALL_REPPROP _ALL_REPFLAVOR_OBJECTS
ALL_REPCOLUMN_GROUP ALL_SDO_GEOM_METADATA _ALL_REPGROUPED_COLUMN
ALL_REPDDL ALL_STREAMS_COLUMNS _ALL_REPL_NESTED_TABLE_NAMES
ALL_REPFLAVOR_COLUMNS ALL_STREAMS_NEWLY_SUPPORTED _ALL_REPPARAMETER_COLUMN
ALL_REPFLAVOR_OBJECTS ALL_STREAMS_UNSUPPORTED _ALL_REPRESOLUTION
Documented No
First Available 10.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtxschnp.plb
 
IS_SCHEMA_PRESENT
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
BEGIN
  RETURN 0;
END;
SELECT xml_schema_name_present.is_schema_present('Larry Ellison', 1)
FROM dual;
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
  FROM (
    SELECT /*+ NO_MERGE */ userenv('SCHEMAID') id2
    FROM dual) u2))

Related Topics
Packages

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-2014 Daniel A. Morgan All Rights Reserved