Answer / suresh.somayajula

po_headers_all is multi org table . in this we can get data

from all branches.

but po_headers is multi org view. in this we can get data
from particular branch.

Answer / meetseshadri

PO_HEADERS_ALL is a table, it holds the data pertaining to
all operating units.

PO_HEADERS is a view,which can be able to hold the data
pertaining to a particular operating unit at runtime.

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

what is global tempory table?

1 Answers   BirlaSoft,

---

What is multi org?

6 Answers   Accenture, CTS,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

what is meant by Drill Down in Discoverer report? why it will be use?

3 Answers   Oracle,

---

In sequence i want to 11 and 15th values how we will write?

0 Answers  

---

what is meant by anchoring?

3 Answers  

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

what is the database size you used?

1 Answers   FIS,

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---