How to perform a loop through all tables in pl/sql?
Answer Posted / chandrakant rathod
We can get all tables for particular instance using below block .
SET SERVEROUTPUT ON;
begin
for rec in (select object_name from user_objects where object_type='TABLE')
loop
dbms_output.put_line('TABLE'||rec.object_name);
end loop;
end;
/
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
describe transaction-safe table types in mysql : sql dba
Can %notfound return null after a fetch?
What is a unique constraint?
What is update query?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
How do you add a column to a table?
Is sql sequential or random?
How to sort the rows in sql.
How global cursor can be declare with dynamic trigger ?
What are the most important characteristics of pl/sql?
how to get a list of indexes of an existing table? : Sql dba
What is date functions?
What is sql comments?
Can we commit inside a trigger?
Which is better join or inner query?