DBA Data[Home] [Help]

VIEW: SYS.USER_XMLTYPE_COLS

Source

View Text - Preformatted

select  SCHEMA_ID, SCHEMA_URL, COL_NAME, QUALIFIED_COL_NAME, TABLE_NAME
from DBA_XMLTYPE_COLS
where TABLE_OWNER = USER
View Text - HTML Formatted

SELECT SCHEMA_ID
, SCHEMA_URL
, COL_NAME
, QUALIFIED_COL_NAME
, TABLE_NAME FROM DBA_XMLTYPE_COLS WHERE TABLE_OWNER = USER