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 can we destroy the cookie? : Sql dba

742


Why do we use joins?

777


What is the difference between clustered and non-clustered index in sql?

733


Can we create view in stored procedure?

687


What is constant in pl sql?

708






How many types of index are there?

724


What is nvarchar max in sql?

752


Does sql between include endpoints?

748


What are inner outer left and right joins in sql?

733


What is an index in sql with example?

712


what is myisam? : Sql dba

758


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1733


What is difference between sql and oracle?

778


What is equi join in sql?

799


What is out parameter used for eventhough return statement can also be used in pl/sql?

800