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

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

How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?

2 Answers   Deloitte, Intelligroup,


what is difference between procedure and function

5 Answers   E Logic,


What are the Standard Reports and Forms in HRMS?

0 Answers  


What are ad-hoc reports?

1 Answers  


In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,






why do we go for oracle apps technical other than sap and other packages?

2 Answers  


Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?

3 Answers   Oracle,


I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????

4 Answers   Satyam,


please send me forms, xml pulisher questions,answers

0 Answers   Zensar,


what is po approval hierarchy?

1 Answers   Cap Gemini,


P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?

9 Answers   CSC, IBM, KPIT, Oracle,


How can we import the data into a database using sql * loader?

0 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)