PL/SQL Procedure to Display Employee Records

PL/SQL Procedure to Display Employee Records:



create or replace procedure disp_emp(ino in number) is
no number;
vname varchar(15);
sal number;
city varchar(15);
begin
select id,name,salary,city into no,vname,sal,city from emp where id=ino;
dbms_output.put_line(no||' '||vname||' '||sal||' '||city);
end;

Calling Procedure:

begin
disp_emp(4);
end;

Leave a Reply

Your email address will not be published. Required fields are marked *

3 − one =