Technicalsymposium.com-Free Email Alerts


Enter Your Email :

Important Note:Login & Check Your Email Inbox and Activate Confirmation Link

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 using Cursor.

declare
cursor c is select name,job,salary from employee;
empname employee.name%type;
jobs employee.job%type;
sal employee.salary%type;

begin
open c;
dbms_output.put_line(' NAME DESIGNATION SALARY');
loop
fetch c into empname,jobs,sal;
exit when c%notfound;
dbms_output.put_line(empname||' '||jobs||' '||sal);
end loop;
close c;
end;

Download All DBMS Study Materials & ebook PDF



DBMS