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

about TCA architecture

1 Answers   TCS,


how to call report from oracle oracle apps11i?

3 Answers   Genpact,


what is multi org structure?

3 Answers   Covansys, TCS,


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

5 Answers   Oracle,


In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers  






Form development process?

1 Answers  


what is pick selection list generation report.

3 Answers  


Can u define operating units inplace of inventory?

2 Answers  


What is invoice?

3 Answers   Murugappa Group,


What is responsibility?

5 Answers  


what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,


What are the different components you should consider while defining a responsibility in oracle apps?

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)