We can use user_tables view of data dictionary. create a cursor based on q

How to perform a loop through all tables in pl/sql?

Question Posted / rahul name

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

Please Help Members By Posting Answers For Below Questions

How to start the command-line sql*plus?

1053

What is the usage of the distinct keyword?

1220

What is user in sql?

1019

What is difference between inner join and cross join?

969

What is difference between function and trigger?

1047

How can you select unique records from a table?

1075

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1073

Why is sharding used?

993

What are the topics in pl sql?

970

What is the meaning of disabling a trigger?

1182

Does sql use python?

1026

What is the difference between microsoft access and sql server?

1057

Which language is used in sql?

1057

What is the need of merge statement?

1038

What is the difference between the conventional and direct path loads? : aql loader

1399