select distinct SCHEMA_URL, SCHEMA_OWNER, SCHEMA_OID,
DEP_SCHEMA_URL, DEP_SCHEMA_OWNER, DEP_SCHEMA_OID
from DBA_XML_SCHEMA_IMPORTS
union
select distinct SCHEMA_URL, SCHEMA_OWNER, SCHEMA_OID,
DEP_SCHEMA_URL, DEP_SCHEMA_OWNER, DEP_SCHEMA_OID
from DBA_XML_SCHEMA_INCLUDES
SELECT DISTINCT SCHEMA_URL
, SCHEMA_OWNER
, SCHEMA_OID
,
DEP_SCHEMA_URL
, DEP_SCHEMA_OWNER
, DEP_SCHEMA_OID
FROM DBA_XML_SCHEMA_IMPORTS
UNION
SELECT DISTINCT SCHEMA_URL
, SCHEMA_OWNER
, SCHEMA_OID
,
DEP_SCHEMA_URL
, DEP_SCHEMA_OWNER
, DEP_SCHEMA_OID
FROM DBA_XML_SCHEMA_INCLUDES
|
|
|