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

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers   Genpact, Y3K Imaginations,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

Registering parametric report?

1 Answers  

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

in ap_terms table what data will be stored

2 Answers   Wipro,

---

What do you understand by a set of books?

0 Answers  

---

What is P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

What is template?

2 Answers  

---

Which module is not in multiorg

6 Answers   HCL, Wipro,

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

what is aim methodolozy

1 Answers  

---

Where we can write a PL/SQL code in report triggers?

2 Answers   IBM,

---