| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Undocumented |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_ANNOTATION_TEXT_METADATA |
USER_SDO_CSW_SERVICE_INFO |
| ALL_EDITION_INHERITED_OBJECTS |
USER_SDO_INDEX_HISTOGRAM |
| ALL_EXTENTS |
WM$COLUMN_PROPS_USER |
| ALL_OBJECTS |
WM$CONS_COLUMNS_USER |
| ALL_OBJECTS_AE |
WM$DBA_TAB_COLS |
| ALL_PROBE_OBJECTS |
WM$INSTEADOF_TRIGS_TABLE_USER |
| ALL_SDO_CSW_SERVICE_INFO |
WM$LOCKROWS_INFO_USER |
| ALL_SDO_INDEX_HISTOGRAM |
WM$MODIFIED_TABLES$_USER |
| ALL_STREAMS_COLUMNS |
WM$NESTED_COLUMNS_TABLE_USER |
| ALL_STREAMS_NEWLY_SUPPORTED |
WM$RIC_LOCKING_TABLE_USER |
| ALL_STREAMS_UNSUPPORTED |
WM$RIC_TRIGGERS_TABLE_USER |
| MDX_ODBO_CUBES |
WM$UDTRIG_DISPATCH_PROCS_USER |
| MDX_ODBO_DIMENSIONS |
WM$UDTRIG_INFO_USER |
| MDX_ODBO_HIERARCHIES |
WM$VERSIONED_TABLES$H_USER |
| MDX_ODBO_LEVELS |
WM$VT_ERRORS_TABLE_USER |
| MDX_ODBO_MEASURES |
WM$WORKSPACES_TABLE_USER |
| MDX_ODBO_PROPERTIES |
|
|
| Documented |
No |
| First Available |
10.1 |
| Security Model |
Owned by SYS with no privileges granted |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtxschnp.plb
{ORACLE_HOME}/rdbms/admin/prvtxschnpb.plb |
| |
| IS_SCHEMA_PRESENT |
Undocumented
In version 12c, before this function was wrapped the function was hard coded to return a 0 no matter what the input
It may be that nothing has changed |
xml_schema_name_present.is_schema_present(
objname IN VARCHAR2,
userno IN NUMBER)
RETURN NUMBER; |
SELECT xml_schema_name_present.is_schema_present('C##APPLIC', 133);
XML_SCHEMA_NAME_PRESENT.IS_SCHEMA_PRESENT('C##APPLIC',133)
-----------------------------------------------------------
0 |
| This demo code was extracted from cdcore.sql in
12c and reformatted for clarity. It is no longer in the database. |
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)); |