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
Can you explain the difference between architecture followed in 10g & 11g?
Do you know where we can check the status of po?
What are the different components of soa suite?
how do you describe O2C along with tables
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?
Are you familiar with internet architecture of oracle apps 11i?
What is count(*) from po_vendors(any table)?
Can you differentiate between mediator and osb?
what is global tempory table?
tell my any difficult situtation you solved in your experience in your company?
Which oracle apps version you are very confident in?
What are the different components you should consider while defining a responsibility in oracle apps?
Can we create tables in apps schema?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
What is a value set? List its various types.