PL/SQL - How do you use cursor dynamically?

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 2 of 166

How do you use cursor dynamically?

Total Answers and Comments: 4

Last Update: August 12, 2007 Asked by: Kishorebabukm

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 22, 2005 08:17:20

scorpio

RE: how do you use cursor dynamically ?

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

Is this answer useful? Yes | No

October 09, 2005 04:54:10

Tez

Member Since: October 2005 Contribution: 5

RE: how do you use cursor dynamically ?

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

Is this answer useful? Yes | No

January 11, 2006 11:22:19

gopal

RE: how do you use cursor dynamically ?

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

Is this answer useful? Yes | No

August 12, 2007 23:51:15

askvenki

Member Since: July 2007 Contribution: 18

RE: how do you use cursor dynamically ?

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank