DBA Data[Home] [Help]

VIEW: SYS.USER_XML_SCHEMA_COMPLEX_TYPES

Source

View Text - Preformatted

select SCHEMA_URL, TARGET_NAMESPACE, COMPLEX_TYPE_NAME, COMPLEX_TYPE,
       BASE_NAME, BASE_SCHEMA_URL, BASE_TARGET_NAMESPACE, MAINTAIN_DOM, SQL_TYPE, SQL_SCHEMA
  from DBA_XML_SCHEMA_COMPLEX_TYPES
  where OWNER = USER
View Text - HTML Formatted

SELECT SCHEMA_URL
, TARGET_NAMESPACE
, COMPLEX_TYPE_NAME
, COMPLEX_TYPE
, BASE_NAME
, BASE_SCHEMA_URL
, BASE_TARGET_NAMESPACE
, MAINTAIN_DOM
, SQL_TYPE
, SQL_SCHEMA
FROM DBA_XML_SCHEMA_COMPLEX_TYPES
WHERE OWNER = USER