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

what is sql? : Sql dba

566


How do you optimize a stored procedure query?

577


What is the sql*loader? : aql loader

595


explain the options of myisamchk to improve the performance of a table. : Sql dba

555


What programs use sql?

536






how many columns can be used for creating index? : Sql dba

528


Can we call procedure in select statement?

533


Does sql between include endpoints?

566


What is attribute indicator in pl sql?

539


Who is the owner of mysql database?

562


What is sql profiling in oracle?

553


How do I save a stored procedure?

536


What is pl sql collection?

535


What are the types of sql commands?

559


What is composite data type in pl sql?

568