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
What is the difference between function, procedure and package in pl/sql?
Which one is better sql or oracle?
What is the difference between truncate and drop statements?
What if we write return in procedure?
Is left join faster than inner join?
What is type and rowtype in pl sql?
What is primary key sql?
How does index help in query performance?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
Do ddl statements need commit?
How many sql statements are used? Define them.
How can we solve sql error: ora-00904: invalid identifier?
What is the use of triggers?
What is a null value?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????