We have to use stored procedure and parameterized cursor.

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

Question Posted / swapna

Answer Posted / swapna

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

1071

how to start mysql server? : Sql dba

1182

Is sql database free?

961

What are sql functions? Describe the different types of sql functions?

1126

Can a view be mutating? If yes, then how?

1009

Can we have two clustered index on a table?

1012

How many sql statements are used? Define them.

1023

Is like operator in sql case sensitive?

1003

Which software is used for pl sql programming?

972

What are the types of views in sql?

1084

What is the use of double ampersand (&&) in sql queries? Give an example

1122

Explain the the update statement in sql?

1017

Is inner join faster than left join?

1175

How many commands are there in sql?

1014

Why do we need cursors in pl sql?

1062