How to perform a loop through all tables in pl/sql?
- 4 Answers
- 15598 Views
- Evosys, MBT, I also Faced
- E-Mail Answers
Answer Posted / rahul name
We can use user_tables view of data dictionary.
create a cursor based on query
select * from user_tables and then use use this cursor
in for loop
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Which language is used in sql?
How many scalar data types are supported in pl/sql?
Inline the values in PL/SQL, what does it mean.?
What are the sql versions?
what is a database transaction? : Sql dba
What is a dynamic query?
What is an exception in pl/sql?
What are the 3 types of behavioral triggers?
What is sqlca in powerbuilder?
Is json a nosql?
Why is %isopen always false for an implicit cursor?
What is clustered index in sql?
Why do we use joins?
what is the difference between delete and truncate statement in sql? : Sql dba
