Oracle PL/SQL Tutorial/System Tables Data Dictionary/all tab comments
Find out all table comments
<source lang="sql">
SQL> SQL> SQL> COLUMN comments FORMAT a45 SQL> SELECT table_name, comments
2 FROM all_tab_comments 3 WHERE table_name = UPPER("&&table_name");
Enter value for table_name: old 3: WHERE table_name = UPPER("&&table_name") new 3: WHERE table_name = UPPER("") no rows selected</source>