Tag: dba_tab_comments

Listing table, view etc. comments in ORACLE

~ hakanboluk ~ Leave a comment

SELECT OWNER,
TABLE_NAME,
COMMENTS
FROM   DBA_TAB_COMMENTS
WHERE  OWNER = :owner
ORDER  BY OWNER,
TABLE_NAME;

Advertisements