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".

in which tables the transaction details stored? at least two.

5 Answers   Scan Steel,

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  

---

What is invoice?

3 Answers   Murugappa Group,

---

What are the requests groups?

3 Answers  

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

Define MultiOrg Structure

5 Answers   Convergys,

---

Can function be overload?

4 Answers  

---

what is the difference between procedure and function

4 Answers  

---

what is instead of trigger. what is the use of that?

3 Answers  

---

why do we go for oracle apps technical other than sap and other packages?

2 Answers  

---

Difference between Bind and Lexical parameters?

3 Answers  

---

Which one Module is Biggest Module in oracle apps?

3 Answers   Questam,

---