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 are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

can u explain which situation automonus transaction is used

2 Answers  

---

when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,

---

tell my any difficult situtation you solved in your experience in your company?

0 Answers   Accenture,

---

List the various types of value set.

0 Answers  

---

What are Mandatory triggers to write in the block, which is created on view?

5 Answers   Oracle,

---

PL/SQL stored procedure parameters?

7 Answers  

---

what are the different transaction clauses in AR?

0 Answers   BirlaSoft,

---

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

1 Answers   PWC,

---

what is user exit and wat program do we write in user exit?

4 Answers   iGate,

---

Can 2 functions have same name & input parameters but differ only by return datatype ?

5 Answers  

---

why do we validate the records while developing interface?

3 Answers   TCS,

---