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

What is catalog in Oracle?

644

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1920

Can we save images in a database and if yes, how?

588

How do I uninstall oracle 11g?

553

How would you go about verifying the network name that the local_listener is currently using?

1602

What is meant by an index?

617

How to define a cusotmer as a supplier in ORACLE R12

1726

Explain the use of tables option in exp command.

589

What are data pump export and import modes?

609

How to convert characters to numbers in oracle?

593

What are the different pseudo commands? Explain in general?

539

How do I find the database name in oracle?

599

State all possible different index configurations a table can possibly have?

562

List out the difference between commit, rollback, and savepoint?

616

What is data file?

612