DBA Data[Home] [Help]

VIEW: SYS.USER_TAB_COMMENTS

Source

View Text - Preformatted

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

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