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 does join work in sql?

1050

What is the difference between syntax error and runtime error?

1178

What is java sql package?

1139

What is difference between inner join and self join?

1133

Can unique keys be null?

947

Why do we need cursor in pl sql?

1187

Can we enter data in a table in design view?

1009

What are the 3 types of behavioral triggers?

1311

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1074

what is the difference between a having clause and a where clause? : Sql dba

1154

Explain the working of foreign key?

1133

What is write ahead logging in sql server?

1096

How to disable a trigger name update_salary?

1307

What is auto increment in sql?

1175

How does postgresql compare to "nosql"?

1078