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

Answer Posted / vikram jayaprakash

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view output in sql developer?

574


How can a pl sql block be executed?

528


What is a table in a database?

574


How many types of cursors supported in pl/sql?

588


Can we use having without group by in sql?

549






How can you load microsoft excel data into oracle? : aql loader

613


Which is faster subquery or join?

656


What is aggregate function in sql?

529


What is pl sql variable?

502


What is use of term?

617


Which is better trigger or stored procedure?

498


What is the requirement of self-join?

540


How many types of literals are available in pl sql?

512


Why use subqueries instead of joins?

603


How do you remove duplicates without using distinct in sql?

499