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

Write an SQL Query to Delete Duplicate records from a table using ROWID.

24 Answers   pspl, Satyam, Thinkways,

---

What are documents and test cases u followed.

2 Answers   Accenture,

---

Is soa a part of oracle fusion middleware?

0 Answers  

---

how i can create temporary table?

1 Answers   Zensar,

---

what is meant by Table space?

2 Answers  

---

Give a brief overview on OrderManagement.

1 Answers   Zensar,

---

what is organization id

2 Answers   Wipro,

---

What is instead of trigger in where we will use?

0 Answers  

---

how can i print random rows in plsql table

0 Answers   Fujitsu, KPIT,

---

Registering parametric report?

1 Answers  

---

What is Pragma Autonomous transaction. It's Real time Example

4 Answers   IBM,

---

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers   PWC,

---