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 ?||5 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||6 No|
What is correlated sub-query?
What is an implicit commit?
what is the difference between a having clause and a where clause? : Sql dba
How to call the function and Procedure in trigger?
What is rownum?
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.
How will you distinguish a global variable with a local variable in pl/sql?
What are the different sql languages?
What is normalisation in sql?
What do you mean by rowid?
IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;
Differentiate between syntax and runtime errors.