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

Answer Posted / swapna

We have to use stored procedure and parameterized cursor.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the authentication modes in sql server? How can it be changed? : Sql dba

712


How do I find duplicates in a single column in sql?

544


What type of database is cloud sql?

590


What is java sql drivermanager?

557


What is difference between sql function and stored procedure?

514






What is dense_rank?

546


How can you create an empty table from an existing table?

602


Can you sum a count in sql?

573


Can we use pl sql in mysql?

525


What is the difference between row level and statement level trigger?

530


How does postgresql compare to "nosql"?

591


Why do we use triggers?

528


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

634


What is relationship? How many types of relationship are there?

599


what is a database lock ? : Sql dba

601