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
How to add new employee details in an employee_details table with the following details
How does a covering index work?
Is left join and outer join same?
What is sql basics?
What is difference between stored function and application function?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
How does sql profiler work?
What is pl sql code?
What is sql in java?
How can you fetch common records from two tables?
Is drop table faster than truncate?
Does google use sql?
What are the advantages of pl sql over sql?
How to look at the current sql*plus system settings?
how to create a table index in mysql? : Sql dba