FUNCTION TO DISPLAY THE SALARY OF EMPLOYEE WHOSE EMPNO IS GIVEN IN ORACLE?



SQL> DECLARE
  2 ECODE EMP.EMPNO%TYPE;
  3 SALARY EMP.SAL%TYPE;
  4 FUNCTION CAL_SAL(E NUMBER) RETURN NUMBER AS
  5 S EMP.SAL%TYPE;
  6 BEGIN
  7 SELECT SAL INTO S FROM EMP WHERE EMPNO=ECODE;
  8 RETURN S;
  9 EXCEPTION
 10 WHEN NO_DATA_FOUND THEN
 11 RETURN 0;
 12 END CAL_SAL;
 13 BEGIN
 14 ECODE := &ECODE;
 15 SALARY:= CAL_SAL (ECODE);
 16 IF SALARY !=0 THEN
 17 DBMS_OUTPUT.PUT_LINE('SALARY IS =  '||SALARY);
 18 ELSE
 19 DBMS_OUTPUT.PUT_LINE('EMPLOYEE DOES NOT
 EXIST');
 20 END IF;
 21 END;
 22 /
Enter value for ecode: 7499
old  14: ECODE := &ECODE;
new  14: ECODE := 7499;
SALARY IS =  2942.05

PL/SQL procedure successfully completed.

SQL> START DISPLAY.SQL;
Enter value for ecode: 7369
old  14: ECODE := &ECODE;
new  14: ECODE := 7369;
SALARY IS =  1469.5

PL/SQL procedure successfully completed.

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. ...
Read more