Thursday, March 8, 2018

PL/SQL - PROCEDURE

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;

No comments:

Post a Comment