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