Installation of Oracle 11g and 12c

*Kindly see the You Tube video to get installed the database.

insert emp

CREATE OR REPLACE PROCEDURE insert_employee (EMPLOYEE_ID IN number, NAME IN VARCHAR2, ADDRESS IN VARCHAR2 ) IS
BEGIN   
    INSERT INTO EMP_T (EMP_ID, NAME, ADDRESS)
    VALUES (EMPLOYEE_ID, NAME, ADDRESS);
END;

procedure p_get_ename_sal_dept_of_emp

create or replace procedure p_get_ename_sal_dept_of_emp
(pv_emp_no in emp_100.empno%type)
as
lv_ename emp_100.ename%type;
lv_sal emp_100.salary%type;
lv_dept emp_100.deptno%type;
begin
  select ename,salary,deptno into lv_ename,lv_sal,lv_dept from emp_100 where empno=pv_emp_no;
  dbms_output.put_line('the emp no'||' '||pv_emp_no||' '||'are..');
    dbms_output.put_line('the name of the  emp'||' '||lv_ename);
    dbms_output.put_line('the emp dept'||' '||lv_dept);
end p_get_ename_sal_dept_of_emp;
  -- select * from emp_100;

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;