Oracle PL/SQL Tutorial/System Tables Data Dictionary/all tab comments
Find out all table comments
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