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

what is po approval hierarchy?

1 Answers   Cap Gemini,


what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,


what is the use of anchors?

2 Answers   IBM,


Can functions be overloaded ?

2 Answers  


If the valueset if of type –TABLE then how many tables can we attach in the valueset ?

5 Answers   Wipro,


what are the different types of parameters avialable in reports?

2 Answers   Oracle,


what is the difference between multiorg views and multiorg tables

2 Answers   Immense Source, Intelligroup, TCS,


about TCA architecture

1 Answers   TCS,


where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,


in ap_terms table what data will be stored

1 Answers  


In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers   Accenture,


where is chandra institute in hyderabad for oracle apps technical training ?

2 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)