How to fetch the rows by dynamicaly passing table name
through cursor?
- 3 Answers
- 9674 Views
- I also Faced
- E-Mail Answers
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
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How many indexes can be created on a table in sql?
what are the differences between require and include, include_once and require_once? : Sql dba
How many types of cursors are available in pl/sql?
Is left join faster than join?
What is the importance of sqlcode and sqlerrm?
what is clause? : Sql dba
Can we connect to postgresql using sql developer?
Is sql sequential or random?
What are pl/sql cursor exceptions?
Whis is not false in primary key?
What are the types of keys?
How is debugging done?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the difference between partition and index?
