we have 10 records. It's occured error in 6th record how
can u find and how to rectify that?
Answer Posted / 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 View All Answers
Tell me how to find the custom directory in front end?
what is global tempory table?
where to define interorganization transaction charges and what are the different options?
In oracle application how do you debug or trace errors?
How can you achieve loose coupling in soa framework?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What are the different components you should consider while defining a responsibility in oracle apps?
How to move the one file from one instance to another instance? And your scripts also?
Can you differentiate between mediator and osb?
tell me the scenarios of the independent in reports
How many schemas we have? how many you have used?
Do you know where we can check the status of po?
What is count(*) from po_vendors(any table)?
How can we import the data into a database using sql * loader?
In sequence i want to 11 and 15th values how we will write?