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