select SCHEMA_URL, TARGET_NAMESPACE, ELEMENT_NAME,IS_REF, TYPE_NAME, GLOBAL,
ELEMENT, SQL_INLINE,SQL_TYPE, SQL_SCHEMA, DEFAULT_TABLE, SQL_NAME,
SQL_COL_TYPE,MAINTAIN_DOM,MAINTAIN_ORDER,ELEMENT_ID,PARENT_ELEMENT_ID
from DBA_XML_SCHEMA_ELEMENTS
where OWNER = USER
SELECT SCHEMA_URL
, TARGET_NAMESPACE
, ELEMENT_NAME
, IS_REF
, TYPE_NAME
, GLOBAL
,
ELEMENT
, SQL_INLINE
, SQL_TYPE
, SQL_SCHEMA
, DEFAULT_TABLE
, SQL_NAME
,
SQL_COL_TYPE
, MAINTAIN_DOM
, MAINTAIN_ORDER
, ELEMENT_ID
, PARENT_ELEMENT_ID
FROM DBA_XML_SCHEMA_ELEMENTS
WHERE OWNER = USER
|
|
|