How to fetch the rows by dynamicaly passing table name through cursor?

How to fetch the rows by dynamicaly passing table name
through cursor?

Question Posted / swapna

3 Answers
9159 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to fetch the rows by dynamicaly passing table name through cursor?..

Answer / swapna

We have to use stored procedure and parameterized cursor.

Is This Answer Correct ?

2 Yes

1 No

How to fetch the rows by dynamicaly passing table name through cursor?..

Answer / vikram jayaprakash

Ref Cursor will come in handy when tables are passed
dynamically.

Is This Answer Correct ?

2 Yes

1 No

How to fetch the rows by dynamicaly passing table name through cursor?..

Answer / madhav

By using ref cursor along with reocord data type(with out
using record type we can't pass the table name dynamically)

cursor refcursor is ref cursor;---weak ref cursor
v_refcursor refcursor----cursor variable
type recordtye is record(table_record table%rowtye,.....)

begin
if not v_recordtype%isopen then
open v_recordtype for select * from emp
end if;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer