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

Which is better Oracle or MS SQL? Why?

5029

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2269

---

How much memory your 10g xe server is using?

1153

---

What is a trigger oracle?

1136

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2005

---

How to use group functions in the select clause using oracle?

1132

---

What is the difference between truncate & delete command?

1233

---

What is the usage of merge statement?

1202

---

Calculate difference between 2 date / times in oracle sql?

1097

---

What is rich query?

1032

---

Explain what does a control file contain?

1160

---

What is a static data dictionary in oracle?

1190

---

What is a package ? What are the advantages of package ?

1136

---

What is pragma autonomous transaction in oracle?

1122

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2040

---