we have 10 records. It's occured error in 6th record how can u find and h

we have 10 records. It's occured error in 6th record how
can u find and how to rectify that?

Question Posted / chandrasekhar.bs

2 Answers
7345 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?..

Answer / srilekha

select * from <Tab_name1> where rownum <=6
minus
select* from <Tab_name1> where rownum<6;

Is This Answer Correct ?

4 Yes

0 No

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?..

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

Is This Answer Correct ?

3 Yes

1 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is multi org structure?

3 Answers Covansys, TCS,

what is fiscalcalendar?

3 Answers CTS,

can we write sql statement in Format trigger?

4 Answers

what is difference between d2k report and oracle apps report

10 Answers Seven Hills, Wipro,

what are the types of interfacing?

3 Answers TCS,

Which one Module is Biggest Module in oracle apps?

3 Answers Questam,

how many sections are there in report?

1 Answers

how to use .prt file in bitmap reports?

2 Answers Accenture,

How to create a link between One dependent value set to another Dependent value set

5 Answers Indorama, ManSoft System, Syntel, TE Data,

in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?

2 Answers Cap Gemini,

What are basic steps for AIM?

2 Answers

how to debug the report?

2 Answers IBM, Qualcomm, Sierra Atlantica,

For more Oracle Apps Technical Interview Questions Click Here