better way is to use the sys.indexes table where it gives the total no row

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

Question Posted / gurudatt

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

Please Help Members By Posting Answers For Below Questions

How to sort the query output in oracle?

967

How to create tables for odbc connection testing?

1003

Does oracle charge for java?

1005

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1043

please explain.. DB architecture ...

1965

What are the different types of record groups in oracle? Explain each of them

969

How to drop an existing view in oracle?

902

Query to retrieve record for a many to many relationship ?

2453

What are the execution control statements in oracle?

1021

State some uses of redo log files?

940

What do you mean by merge in oracle and how can you merge two tables?

902

How many types of auditing in Oracle?

977

How to write date and time literals in oracle?

944

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2208

Please explain joins in oracle?

1007