Answer / srilekha

select * from <Tab_name1> where rownum <=6
minus
select* from <Tab_name1> where rownum<6;

Answer / nithya

To retrieve data:

select * from <table_name> a where 6 = (select count(rowid)
from <table_name> b where a.rowid>=b.rowid);

u can rectify it using the same "sub-query".

where we find the status of order information.

2 Answers  

---

what is the use of placeholer column?

3 Answers  

---

what is the differences between internal requisition and internal sales order?

0 Answers   Accenture,

---

Attribute data types?

2 Answers  

---

Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,

---

---

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---

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,

---

where the accounting related data is stored ?

2 Answers  

---

how do you describe O2C along with tables

0 Answers   TCS,

---

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

---

What are ad-hoc reports?

1 Answers  

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---