scorpio

• Sep 22nd, 2005

 

Ref Cursor are used for retrieving the values from an sql dynamically.

Tez

 Profile Answers by Tez 

• Oct 9th, 2005

 

CURSORs are nothing but , memory locations created temporarily for the ease of maintanance by having the data in the local computer......(No need to go to the Database for every row)..... We can dynamically fetch the rows as we like. . using cursor.....CURSOR is something like a ResultSet

gopal

• Jan 11th, 2006

 

Dear sir,

      declare

       dep_num number;

         cursor c(x number) is select * from emp where deptno=x;

    begin

           select deptno into dep_num from emp where empno=7568;

         open c(dep);

       end;

with regards,

gopal

askvenki

 Profile Answers by askvenki 

• Aug 12th, 2007

 

By using cursor parameters we can pass the value dynamically. So that cursor can fetch data as per parameter