|
SQL>
SQL> create table salgrades
2 ( grade NUMBER(2) constraint S_PK
3 primary key
4 , lowerlimit NUMBER(6,2) constraint S_LOWER_NN
5 not null
6 constraint S_LOWER_CHK
7 check (lowerlimit >= 0)
8 , upperlimit NUMBER(6,2) constraint S_UPPER_NN
9 not null
10 , bonus NUMBER(6,2) constraint S_BONUS_NN
11 not null
12 , constraint S_LO_UP_CHK check
13 (lowerlimit <= upperlimit)
14 );
Table created.
SQL>
SQL>
SQL> drop table salgrades;
Table dropped.
SQL>
SQL>
|