DBA Data[Home] [Help]

VIEW: SYS.USER_COL_COMMENTS

Source

View Text - Preformatted

select TABLE_NAME, COLUMN_NAME, COMMENTS, ORIGIN_CON_ID
from NO_ROOT_SW_FOR_LOCAL(INT$DBA_COL_COMMENTS)
where OWNER = SYS_CONTEXT('USERENV', 'CURRENT_USER')
View Text - HTML Formatted

SELECT TABLE_NAME
, COLUMN_NAME
, COMMENTS
, ORIGIN_CON_ID FROM NO_ROOT_SW_FOR_LOCAL(INT$DBA_COL_COMMENTS) WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')