How to perform a loop through all tables in pl/sql?
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
When are we going to use truncate and delete?
What are the indexing methods?
What is consistency?
Show how functions and procedures are called in a pl/sql block.
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Is sql procedural language?
What is scalar data type in pl sql?
What is rowtype?
what is 'mysqlimport'? : Sql dba
What are different types of queries in sql?
what is data control language? : Sql dba
Explain about various levels of constraint.
What does select count (*) mean in sql?
Why is partition used in sql?
What are the two characteristics of a primary key?