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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
List the types of flexfield?
what are the balancing segments in AR?
how can i print random rows in plsql table
Can you define an erp system?
What does appl_top directory contain?
how to print multi lay outs,muti currency,muti language in xml publisher
What is oracle soa suite?
How can you achieve loose coupling in soa framework?
Explain what are the tables of auto invoice?
What is a value set? List its various types.
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
What is the concept of soa governance?
How to move the one file from one instance to another instance? And your scripts also?