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

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,

---

In Oracle Apps Some tables ends with TL,VL,what is the significance of the TL and VL?

9 Answers   TCS,

---

what do you mean by value sets

8 Answers   Convergys,

---

How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers  

---

---

What are the Major differences between appcore.pll and appcore2.pll

4 Answers   Infosys, Sierra Atlantica,

---

What and Who is the best Institute or Trainer for Oracle Apps Technical ?

2 Answers  

---

How to call oracle database stored procedure from form in form coding ?

3 Answers   Oracle,

---

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

---

What is ment by Global Templates in Oracle.

1 Answers   IBM,

---

Can anybody tell me, What is the Implementation Process?

2 Answers   TCS,

---

what is organization id

3 Answers  

---