PROGRAM TO INCREASE THE SALARY OF EMPLOYEES IN ORACLE?



 SQL> DECLARE
        2   CURSOR SAL_DATA IS
        3   SELECT EMPNO, JOB FROM EMP;
        4   ECODE EMP.EMPNO%TYPE;
        5   POST EMP.JOB%TYPE;
        6   BEGIN
        7   OPEN SAL_DATA;
        8   LOOP
        9   FETCH SAL_DATA INTO ECODE, POST;
       10   EXIT WHEN SAL_DATA%NOTFOUND;
       11   IF POST='MANAGER' THEN
       12   UPDATE EMP SET SAL=SAL*1.10 WHERE       
              EMPNO=ECODE;
       13   ELSIF POST='CLERK' THEN
       14   UPDATE EMP SET SAL =SAL*1.08 WHERE 
              EMPNO=ECODE;
       15   ELSIF POST='ANALYST' THEN
       16   UPDATE EMP SET SAL=SAL*1.09 WHERE
              EMPNO=ECODE;
       17   ELSIF POST='PRESIDENT' THEN
       18   UPDATE EMP SET SAL=SAL*1.50 WHERE  
              EMPNO=ECODE;
       19   END IF;
       20   END LOOP;
       21   CLOSE SAL_DATA;
       22   END;
       23       /

PL/SQL procedure successfully completed.

  SQL> START INCREASESAL.SQL;

PL/SQL procedure successfully completed.
SQL> SELECT SAL FROM EMP;

      SAL
    ---------
   1269.5
  2042.05
  1595.36
   5270.4
  1595.36
  5048.96
  4340.34
   3564.3
    11250
  1914.42
  1745.55
  1507.54
   3564.3
  2062.94

14 rows selected.

Comments

Post a Comment

Popular posts from this blog

Write a program to add two number using inline function in C++?

#include<iostream.h> #include<conio.h> class bca {   public:   inline int sum(int x, int y)   {   return(x+y);   } }; int main() { clrscr(); int r,a,b; bca obj; cout<<"enter two integers :"<<endl; cin>>a>>b; r=obj.sum(a,b); cout<<" the sum of two integers is :"<<r<<endl; getch(); return 0; }   OUTPUT:- enter two integers :    3    6 the sum of two integer is :   9  
Read more

Traversing of elements program with algorithm and Flowchart

Image
ALGORITHM VARIABLES: §   i:      loop counter of array. §   A:    array name. §   LB: lower bound. §   UB: upper bound. ALGORITHM: STEP 1:         set i =LB STEP 2:         repeat steps 3 & 4                            While i<=UB STEP 3:         apply process to A[i] STEP 4:         i = i+1            STEP 5:         exit EXPLANATION: §   To traverse the elements of the array, firstly set the loop counter ‘i’ equal to last element of the array called the LOWER BOUND. §   Now, repeat step 3 & 4 for accessing all the elements of the array until loop counter ‘i’ is not less than or equal first element of array. §   Now, after checking the above condition, the whole process will repeat for all the elements of array. §   After applying process upon a[i], increment the loop counter by 1, until the condition is not satisfied. IMPLEMENTATION
Read more