technicalsymposium

Google Search-Search in Our Website

Search Freshers Jobs/Conferences/Placement Materials/ All Engineering Branches Lecture Notes and
GATE/All Universities Question Papers in Our Website. Enter your Query & Search Below

PL/SQL Technical Program-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;

Hosting by Yahoo!

About-Us    Contact-Us    Site-map

©copyright All rights are reserved to technicalsymposium.com