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

What is PL/SQL ?

2063

---

What is index-organized table in Oracle?

1069

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1156

---

What is a database table in oracle?

1022

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1994

---

Describe an oracle table?

1049

---

How to check the oracle tns settings?

1047

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1690

---

How to execute a stored program unit?

1075

---

How to select some columns from a table in oracle?

1093

---

Explain the use of Merge statement in oracle 11g

1028

---

How to increment dates by 1 in oracle?

1085

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1082

---

What is redo log?

1065

---

How to open a cursor variable?

1036

---