Join Our Email Alerts-Subscribe
Important Note:Login & Check Your Email Inbox and Activate Confirmation Link



Enter Your Email :


Programming Souce Codes & ebooks-Free Download

Free ebooks

Programming Study Materials & ebooks

Online Training


PL SQL Program For TO RETRIEVE THE RECORDS OF THE EMPLOYEE.

declare
no emp.empno %type;
name emp.emp_name %type;
sal emp.salary %type;
begin
no:=&no;
select emp_name,salary into name,sal from emp where empno=no;
dbms_output.put_line(' DETAILS OF THE EMPLOYEE WHOSE EMPLOYEE NO IS '||no);
dbms_output.put_line('Name of the Employee : ' || name);
dbms_output.put_line('Salary of the Employee : ' || sal);
exception
when No_data_found then
dbms_output.put_line('The Employee Number ' || no || ' Not Found');
end;

 


All Programming Codes/Onlie Training/ Lab Manuals Download