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?

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


Please Help Members By Posting Answers For Below Questions

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?

1110


List the types of flexfield?

1088


what are the balancing segments in AR?

2150


how can i print random rows in plsql table

2572


Can you define an erp system?

1226


What does appl_top directory contain?

1168


how to print multi lay outs,muti currency,muti language in xml publisher

12394


What is oracle soa suite?

1299


How can you achieve loose coupling in soa framework?

1275


Explain what are the tables of auto invoice?

1196


What is a value set? List its various types.

1144


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3113


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2261


What is the concept of soa governance?

1320


How to move the one file from one instance to another instance? And your scripts also?

1175