Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



we have 10 records. It's occured error in 6th record how can u find and how to rectify that?..

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

we have 10 records. It's occured error in 6th record how can u find and how to rectify that?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

in reports token is casesensitive or not?

2 Answers  


how can we return morethan one parameters in procedure?

2 Answers  


In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,


where to define interorganization transaction charges and what are the different options?

0 Answers   Scan Steel,


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?

1 Answers  


What is menu.

2 Answers   Accenture,


How can we import the data into a database using sql * loader?

0 Answers  


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.

6 Answers   Tech Mahindra,


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

0 Answers  


In custom.pll what are the events we can Not write.

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)