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



Enter Your Email :

Copyright Disclaimer:
Section 107 of the Copyright Act Fair Use Contents .
We are forwarding content link(s) from our website to content website & We are not serving any contents.
Main Source:Google.com.All the Content PDF link(s) is/are obtained from GoogleSearch
for the purpose of Education & Teaching Intention. Not for commercial purpose.
Technicalsymposium.com is not liable/responsible for any copyright issues.

DBMS Programming Source Codes & Study Notes-Free Download



Free Download of All Study Materials & ebooks PDF-Click & 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;

 


Technicalsymposium.com-Free Study Materials PDF-Download




Technicalsymposium.com-Download All Study Notes PDF




Technicalsymposium.com-Free Live Support-Chat with Our Experts

Official Contact: +91-9245556793 (Whatsapp Message / SMS / Voice Call)


Our Expert team is ready to answer all your questions immediately-Feel free to speak in Tamil/English.

(Example:Events info/Lecture Notes/Off-Campus & All Jobs/Projects & All education information)

Working hrs (IST): (Morning: 10:00AM-3:00 PM) and (Evening:5:00 PM to 10:00 PM)

All Latest Question & Answer Page (FAQ)-Click here