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

Give the various rollback segment states.

1031

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4150

---

How to assign query results to variables?

1033

---

How to login to the server without an instance?

1144

---

How to enter a new row into a table interactively?

993

---

What is a nvl function?

996

---

Difference between hot backup vs. Cold backup?

968

---

What are the oracle differences between nvl and coalesce

1126

---

What is oracle update statement with inner join ?

1032

---

How to create a new table in oracle?

1132

---

What privilege is needed for a user to insert rows to tables in another schema?

990

---

What is meant by a deadlock situation?

1090

---

How to use an explicit cursor without open statements?

1040

---

What are the data types in oracle?

1018

---

What is the meaning of recursive hints in oracle?

1034

---