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 ?||3 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||5 No|
Is it possible to use LONG columns in WHERE clause or ORDER BY?
What is materialised View?
25.67,-1 Trunc = 20 Round= 30 HOW????
How to return more than one value from a function?
what is meant by DML?
what is the difference between trigger and constraint?
what is the difference between pragma exception_init and raise_application_error
write a query to delete similar records in different tables with same structure
Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)
wtite down triggr not any entry on Sunday
is it mandatory to select all the column in a view then what columns should be selected
full outer join syntax