|
SQL>
SQL> create table salgrades
2 ( grade NUMBER(2)
3 , lowerlimit NUMBER(6,2)
4 , upperlimit NUMBER(6,2)
5 , bonus NUMBER(6,2)
6 ) ;
Table created.
SQL>
SQL>
SQL> comment on column salgrades.bonus
2 is 'For sales reps only';
Comment created.
SQL>
SQL>
SQL>
SQL> select comments
2 from user_col_comments
3 where table_name = 'SALGRADES'
4 and column_name = 'COMM';
no rows selected
SQL>
SQL> drop table salgrades;
Table dropped.
SQL>
SQL>
|