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 |
in reports token is casesensitive or not?
how can we return morethan one parameters in procedure?
In Per_all_people_f table what is the significance of '_f ' ?
where to define interorganization transaction charges and what are the different options?
hi friends! i need sample codes for oracle apps 11i conversion and interfaces.If u have,plz send me
2 Answers Pathway Technologies,
Form development process?
What is menu.
How can we import the data into a database using sql * loader?
INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using >CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.
How many types of projects are there in project module?
6 Answers Fujitsu, Tech Mahindra,
Can u give the Documentation of Custom.pll in oracle apps
In custom.pll what are the events we can Not write.