[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