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

Can you have two stored functions with in the same name?

3 Answers  

---

what is the difference between oracle 8i and 9i?

1 Answers  

---

What is Formula Column?

4 Answers  

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

How to create user and how u attach with responsibility.

2 Answers   Accenture,

---

Name the different Cursor Attributes.

2 Answers   Satyam,

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

How can u populate data into po_headers_all segment2 column?

1 Answers   BirlaSoft,

---

LOCKS?

1 Answers  

---

How to create a purchase order without a requisition?

0 Answers  

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

what is the difference between request group and request security group in oracle apps?

2 Answers   BirlaSoft,

---