Subscribe & Get All Fresher Jobs Information & Study Materials PDF and Projects- Free Download
DBMS Study Notes PDF
DBMS Tech Interview Q & A PDF
DBMS Latest Projects
DBMS Projects & All Latest Projects PDF- Free Download
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;
