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

What is FORWARD DECLARATION in Packages?

6 Answers   British Telecom BT, HCL, Tech Mahindra,

---

wht is the use of Xml reports over reports6i?

5 Answers  

---

Attribute data types?

2 Answers  

---

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

9 Answers   TCS,

---

what is the data type of lexical parameter?

5 Answers   Wipro,

---

how can u link a org-id with a responsibility in reports?

2 Answers   TCS,

---

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

---

how to create a file in forms?

3 Answers   Wipro,

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

in procedure how to return a value

3 Answers  

---

how to create requst set in oracle apps and how to send muliple requests at a time,

1 Answers   Genpact,

---