Oracle PL/SQL Tutorial/System Tables Data Dictionary/all tab comments

Материал из SQL эксперт
Перейти к: навигация, поиск

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>