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

Why cross join is used?

1074

What is an exception in pl/sql?

1075

Can function return multiple values in sql?

1049

What is nosql db?

960

What is full join in sql?

984

Mention what pl/sql package consists of?

990

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

988

What is the difference between a query and a report?

962

What is right join in sql?

1084

Can we use commit inside a trigger?

1080

What is meant by user defined function?

1042

What are the advantages of stored procedure?

1000

What's the difference between inner join and left join?

997

What is not in sql?

941

What is update query?

972