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 can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

What is Referential Integrity?

3 Answers  

---

Explain the significance of the & and && operators in pl sql.

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

What is the difference between inner join and outer join?

0 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

List the various privileges that a user can grant to another user?

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

What is dynamic sql in pl sql?

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

what is commit? : Sql dba

0 Answers  

---