Oracle XML_SCHEMA_NAME_PRESENT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
ALL_ANNOTATION_TEXT_METADATA ALL_STREAMS_NEWLY_SUPPORTED MDX_ODBO_HIERARCHIES
ALL_OBJECTS ALL_STREAMS_UNSUPPORTED MDX_ODBO_LEVELS
ALL_OBJECTS_AE ALL_WM_VERSIONED_TABLES MDX_ODBO_MEASURES
ALL_PROBE_OBJECTS DV$OUT MDX_ODBO_PROPERTIES
ALL_SDO_CSW_SERVICE_INFO MDX_ODBO_CUBES USER_SDO_CSW_SERVICE_INFO
ALL_SDO_INDEX_HISTOGRAM MDX_ODBO_DIMENSIONS USER_SDO_INDEX_HISTOGRAM
ALL_STREAMS_COLUMNS    
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;

XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT('LARRYELLISON',1)
-----------------------------------------------------------
                                                          0
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
Built-in Functions
Built-in Packages
What's New In 19c
What's New In 20c-21c

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
  DBSecWorx