Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Find out all table comments

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