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;
