Add constraint to ensure that value from one column is bigger than that from another
SQL>
SQL>
SQL> create table salary
2 ( grade NUMBER(2) constraint S_PK
3 primary key
4 , lowerlimit NUMBER(6,2)
5 , upperlimit NUMBER(6,2)
6 , bonus NUMBER(6,2)
7 , constraint S_LO_UP_CHK check (lowerlimit <= upperlimit)
8 ) ;
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>
SQL>
SQL> select * from salary
2 where grade > 3;
GRADE LOWERLIMIT UPPERLIMIT BONUS
---------- ---------- ---------- --------
4 2001 3000 200.00
5 3001 9999 500.00
SQL> COL bonus FOR 9999.99
SQL> /
GRADE LOWERLIMIT UPPERLIMIT BONUS
---------- ---------- ---------- --------
4 2001 3000 200.00
5 3001 9999 500.00
SQL>
SQL>
SQL> drop table salary;
Table dropped.
Related examples in the same category