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
Do prepared statements prevent sql injection?
What is a primary key? Explain
Explain polymorphism in pl/sql.
What is an index in sql with example?
What is difference between stored procedures and application procedures?
How sql query is executed?
What is difference between procedure and trigger?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Explain the uses of control file.
Is sql a backend language?
How do I partition in sql?
What is informix sql?
How much ram can sql express use?
How do I debug a stored procedure?
What is difference between joins and union?