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

What is the difference between database trigger and stored procedure?

1007

What is sql server and ase?

978

Which operator is used in query for pattern matching?

1034

what is foreign key? : Sql dba

971

Which are the different case manipulation functions in sql?

955

Is inner join same as self join?

1063

Can you inner join the same table?

938

Is vs as in pl sql?

935

How do I get sql certification?

926

how do you know if your mysql server is alive? : Sql dba

1027

What is the difference between union and union all command?

1009

Why we use cross join?

890

What is latest version of sql?

983

Can we write dml inside a function in sql server?

900

Which join is like an inner join?

954