Interested to Buy Any Domain ? << Click Here >> for more details...
How to perform a loop through all tables in pl/sql?
- 4 Answers
- 16838 Views
- Evosys, MBT, I also Faced
- E-Mail Answers
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
What is user defined functions?
What does pl sql developer do?
What are user defined functions?
How exception is different from error?
Explain scalar functions in sql?
What are the two types of periodical indexes?
What is dynamic query?
What are the different types of functions in sql?
What is replication id?
Can we use view in stored procedure?
What is database sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is function and procedure?
Is sql a scripting language?
What is offset and limit in sql?
