create or replace procedure proc1
is
l_id integer;
begin
select employee_id
into l_id
from employees
where first_name = 'Suriya Parithy';
dbms_output.put_line(l_id);
end;
exec proc1;
is
l_id integer;
begin
select employee_id
into l_id
from employees
where first_name = 'Suriya Parithy';
dbms_output.put_line(l_id);
end;
exec proc1;
No comments:
Post a Comment