Answer / 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;
/

Answer / rahul name

We can use user_tables view of data dictionary.
create a cursor based on query
select * from user_tables and then use use this cursor
in for loop

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

Answer / mahesh gulati

select * from sysobjects where type = 'u'

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

What is PL/SQL table ?

6 Answers  

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---

How much does sql certification cost?

0 Answers  

---

How do you exit in sql?

0 Answers  

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

How to run pl sql program in mysql?

0 Answers  

---

What is the sql case statement?

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

Is primary key clustered or nonclustered?

0 Answers  

---