How to perform a loop through all tables in pl/sql?
Answers were Sorted based on User's Feedback
Answer / chandrakant rathod
We can get all tables for particular instance using below block .
SET SERVEROUTPUT ON;
for rec in (select object_name from user_objects where object_type='TABLE')
|Is This Answer Correct ?||6 Yes||0 No|
Answer / highness
I got a lot of definitions for this but i thing this is right
A compiled plsql procedure
stands for a stored procedure...
check out this
|Is This Answer Correct ?||1 Yes||2 No|
Answer / mahesh gulati
select * from sysobjects where type = 'u'
|Is This Answer Correct ?||3 Yes||7 No|
How to create a menu in sqlplus or pl/sql?
What type of join is sql join?
Name three sql operations that perform a sort.
What is $$ in sql?
How sql query is executed?
Does sqlite need a server?
What is normalisation in sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What are different types of indexes?
Can variables be used in sql statements?
what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
what is a unique key ? : Sql dba