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 |
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
what is difference between procedure and function
What are the Standard Reports and Forms in HRMS?
What are ad-hoc reports?
In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?
why do we go for oracle apps technical other than sap and other packages?
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that?
I Have report which is having field at the end of page,,, problem is when i run report data is overflowing to the next page,,i want the data to come on same page can anybody help me out????
please send me forms, xml pulisher questions,answers
what is po approval hierarchy?
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
How can we import the data into a database using sql * loader?