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
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 |
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 |
about TCA architecture
how to call report from oracle oracle apps11i?
what is multi org structure?
What are Mandatory triggers to write in the block, which is created on view?
In which directory your flatfile is given?if u connected different instance where it is find?
Form development process?
what is pick selection list generation report.
Can u define operating units inplace of inventory?
What is invoice?
What is responsibility?
what are centralized and decentralized level of control of item attributes?
What are the different components you should consider while defining a responsibility in oracle apps?