Answer Posted / nanne

Your Question is not clear..i believe that your expecting retrieve the tables which are having zero rows in the database.

Yes...we can retrieve the zero rows tables from DB

Select * from dba_tables
where num_rows = 0;

Regards,
Nanne

Explain the function of optimizer in oracle?

1073

---

11. Display the client number and name and the client number and name of the person who referred that client.

2285

---

How to get the Installed Oracle Version Information ?

1088

---

What is a subquery in oracle?

1052

---

Can multiple columns be used in group by in oracle?

937

---

defination of bitmap index

2057

---

What is query image?

933

---

How to define a sub function?

1096

---

What is a system tablespace and when it is created?

928

---

What is an Oracle Instance?

1081

---

How to write date and time literals in oracle?

958

---

How to recover a dropped table in oracle?

988

---

What the is the diff between local index and global index. give some example.

1595

---

What is a sub query? What are its various types?

1092

---

What is tns service name?

1087

---