|
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> insert into salary values (1, 700,1200, 0);
1 row created.
SQL> insert into salary values (2, 1201,1400, 50);
1 row created.
SQL> insert into salary values (3, 1401,2000, 100);
1 row created.
SQL> insert into salary values (4, 2001,3000, 200);
1 row created.
SQL> insert into salary values (5, 3001,9999, 500);
1 row created.
SQL>
SQL> select * from salary;
[Enter]...
GRADE LOWERLIMIT UPPERLIMIT BONUS
---------- ---------- ---------- --------
1 700 1200 .00
2 1201 1400 50.00
3 1401 2000 100.00
4 2001 3000 200.00
5 3001 9999 500.00
5 rows selected.
SQL> set colsep " | "
SQL> set numwidth 10
SQL> /
[Enter]...
GRADE | LOWERLIMIT | UPPERLIMIT | BONUS
---------- | ---------- | ---------- | --------
1 | 700 | 1200 | .00
2 | 1201 | 1400 | 50.00
3 | 1401 | 2000 | 100.00
4 | 2001 | 3000 | 200.00
5 | 3001 | 9999 | 500.00
5 rows selected.
SQL> set colsep " "
SQL>
SQL> drop table salary;
Table dropped.
SQL>
|