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

Please explain compound trigger in oracle?

1007

---

Differentiate between translate and replace?

1054

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

972

---

When do we use group by clause in a sql query?

1001

---

Explain what does a control file contain?

1046

---

can u plz provide me oca sql dumps please i need them

1911

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2298

---

How to handle a single quote in oracle sql?

986

---

How to export data to a csv file?

1231

---

Is there a function to split a string in plsql?

1000

---

What is sequence?

1022

---

What is the parameter mode that can be passed to a procedure?

994

---

What is the sql query to concatenate column values from multiple rows in oracle?

1008

---

How to rename a tablespace in oracle?

1046

---

Explain user account with reference to oracle.

940

---