Comment table and check user_col_comments : Comment Table « Table « Oracle PL / SQL






Comment table and check user_col_comments

 
SQL>
SQL> create table emp
  2  ( empno      NUMBER(4)    constraint E_PK primary key
  3  , ename      VARCHAR2(8)
  4  , init       VARCHAR2(5)
  5  , job        VARCHAR2(8)
  6  , mgr        NUMBER(4)
  7  , bdate      DATE
  8  , sal       NUMBER(6,2)
  9  , comm       NUMBER(6,2)
 10  , deptno     NUMBER(2)    default 10
 11  ) ;

Table created.

SQL>
SQL> create table salary
  2  ( grade      NUMBER(2)   constraint S_PK primary key
  3  , lowerlimit NUMBER(6,2)
  4  , upperlimit NUMBER(6,2)
  5  , bonus      NUMBER(6,2)
  6  , constraint S_LO_UP_CHK check (lowerlimit <= upperlimit)
  7  ) ;

Table created.

SQL>
SQL> comment on table salary
  2  is     'Salary grades and net bonuses';

Comment created.

SQL>
SQL> comment on column emp.comm
  2  is     'For sales reps only';

Comment created.

SQL>
SQL> select comments
  2  from   user_tab_comments
  3  where  table_name  = 'SALARY';

SQL>
SQL> select comments
  2  from   user_col_comments
  3  where  table_name  = 'EMP'
  4  and    column_name = 'COMM';

no rows selected

SQL>
SQL> drop table emp;

Table dropped.

SQL> drop table salary;

Table dropped.

   
  








Related examples in the same category

1.Add a comment on a table
2.Remove a comment from table
3.Comment on table column
4.Print out comment for a given table