Is it possible to pass table name as input parameter into the cursor?
cursor my_cur(table_name varchar2) is
select column from table_name
Printable View
Is it possible to pass table name as input parameter into the cursor?
cursor my_cur(table_name varchar2) is
select column from table_name
Yes. If the table_name is a regular pl/sql variable and you have previously selected the tablename into that variable from one of the data dictionary views.
Could yuo write ma an example.
I have tried that but it's not working.
post your example