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...

how do u know the total no of rows in a table?

Answer Posted / gurudatt

better way is to use the sys.indexes table where it gives the total no rows for each table.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What types of joins are used in writing subqueries?

945


How to compare dates in oracle sql?

1062


Give the different types of rollback segments.

986


If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2254


Is there an oracle sql query that aggregates multiple rows into one row?

944


What privilege is needed for a user to query tables in another schema?

935


How to use subqueries with the in operator using oracle?

1052


What is the difference between I and G in Oracle?

1036


What is an oracle user role?

945


What is data block in Oracle?

1063


What is background process in Oracle?

1063


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2157


Differentiate between pre-select and pre-query?

1061


How do I start tns listener?

997


How will you write a query to get a 5th rank student from a table student_report?

1823