Oracle database table row count

Question

I want to take a table row count of a particular table precisely in my application. Rather than running a SQL count query, Is there way to fetch a table row count from oracle database engine?

I'm afraid what you need is nonsense. Oracle does know it, it is not necessary maintain such an information. Even if there was a way, such a value is usually useless, when running in multi-user concurrent environment. Before the value is sent to you, it can be different in reality. ALL_TABLES view contains a value from the last statistics gathering. — ibre5041
– ibre5041, Commented May 29, 2015 at 7:41

Rahul Tripathi · Accepted Answer · 2015-05-29 07:26:38Z

1

No there is no way by which you can achieve rows it directly from Oracle database engine.

However if you dont want to use COUNT query then there are other ways by which you can get the result faster in case your table is huge like

SELECT NUM_ROWS FROM ALL_TABLES WHERE TABLE_NAME = your_table_name;

answered May 29, 2015 at 7:26

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

user1516815 Over a year ago

I tried the query you provided, but it gives me Null. But my table is not empty

Rahul Tripathi Over a year ago

@user1516815:- Can you show the query which you have tried?

user1516815 Over a year ago

SELECT NUM_ROWS FROM ALL_TABLES WHERE TABLE_NAME = 'STUDENTLOG';

Rahul Tripathi Over a year ago

@user1516815:- And what does select count(*) from STUDENTLOG returns?

Rahul Tripathi Over a year ago

@user1516815:- If you want you can use the exec DBMS_STATS.GATHER_DATABASE_STATS; This will update the statistics. You can refer this: docs.oracle.com/cd/B28359_01/appdev.111/b28419/…

|

Collectives™ on Stack Overflow

Oracle database table row count

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related