How do you find the numbert of rows in a Table ?

A bad answer is count them (SELECT COUNT(*) FROM table_name)
A good answer is :-
'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g. USER_TABLES or ALL_TABLES).
The best answer is to refer to the utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.
  • Interview Candidate
  • 3
  • 2592

Showing Answers 1 - 3 of 3 Answers

rajaramian

  • Feb 8th, 2006
 

Following query will help to find out number of rows in a table

select count(*) from <table_name>;

  Was this answer useful?  Yes

gony

  • Feb 8th, 2006
 

use SY-DBCNT. It is used to count number of rows in a databse table.in internal tables we use SY-TABIX.cheers dude....bye

  Was this answer useful?  Yes

safdar

  • Sep 4th, 2007
 

If you want to find the number of Rows in table
SELECT COUNT(*) FROM EMP;
This is valid query

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions