I am new to PL/SQL.Can some one help me in this PL/SQL procedure?

Vote count:

0

Write a PL/SQL procedure which takes employee number and salary as input parameters and delete from employees table whose manager is 'BLAKE' and salary between 1000 and 2000.

I have written below code :-

create  or replace procedure processing(v_emp_no in emp1.empno%type,v_salary in emp1.sal%type)
is 
begin

select empno,sal into v_emp_no,v_salary
from emp where ename = 'BLAKE' and sal between 1000 and 2000;
delete from emp1
where empno  = v_emp_no
and sal = v_salary; 
end;

asked 1 min ago

Adil

1

I am new to PL/SQL.Can some one help me in this PL/SQL procedure?