Sunday, February 7, 2016

Proc_p_emp_info (I_deptno)- to display emp info

create or replace procedure p_emp_info (I_deptno in emp_100.deptno%type)
as
    cursor cur_empinfo is
    select empno,ename,salary from emp_100 where deptno=I_deptno;
            lv_emprecord    cur_empinfo%rowtype;
            lv_empname      emp_100.ename%type;
            lv_salary       emp_100.salary%type;
            lv_avg_salary   emp_100.salary%type;
            lv_max_salary   emp_100.salary%type;
            /*lv_exp number(4,2);=1;*/
begin
  open cur_empinfo;
  loop
    fetch cur_empinfo into lv_emprecord;
    exit when cur_empinfo%notfound;
    dbms_output.put_line ('EMPOLYEE NAME     : '||lv_emprecord.ename);
    dbms_output.put_line ('EMPOLYEE SALARY   : '||lv_emprecord.salary);
    /*lv_exp:=empExp(cur_empinfo.empno);*/
   /* dbms_output.put_line ('EMPOLYEE"S exp    : '||lv_emprecord.lv_exp);*/
    dbms_output.put_line ('****************************************');
   /* lv_salary:=lv_salary+cur_empinfo.SALARY;*/
   END LOOP;
   CLOSE  cur_empinfo;
END;

No comments:

Post a Comment

Installation of Oracle 11g and 12c *Kindly see the You Tube video to get installed the database.