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 |
what is po approval hierarchy?
what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?
what is the use of anchors?
Can functions be overloaded ?
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
what are the different types of parameters avialable in reports?
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
about TCA architecture
where we will put the control file ,where we will run sql star loader what is the cmd?
in ap_terms table what data will be stored
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
where is chandra institute in hyderabad for oracle apps technical training ?