|
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> select comments
2 from user_tab_comments
3 where table_name = 'SALGRADES';
COMMENTS
----------------------------------------------------------------------------------------------------
SQL>
SQL> drop table salgrades;
Table dropped.
SQL>
|