Column calculation : Calculation in Query « Select Query « Oracle PL / SQL






Column calculation

    

SQL>
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 grade, upperlimit - lowerlimit
  2  from   salary;

     GRADE UPPERLIMIT-LOWERLIMIT
---------- ---------------------
         1                   500
         2                   199
         3                   599
         4                   999
         5                  6998

SQL>
SQL> drop table salary;

Table dropped.

SQL>

   
    
    
    
  








Related examples in the same category

1.Do calculation in select query
2.Expressions in query
3.Performing Mathematics
4.Number column calculation
5.Using Expressions: (Mark * 100) / 80.0 AS ActualPercentage