Showing posts with label Row count. Show all posts
Showing posts with label Row count. Show all posts

Monday, 10 August 2015

How to find the number of row in oracle table using sql:-

       /* Formatted on 8/10/2015 4:31:56 PM (QP5 v5.240.12305.39446) */

                      SELECT TABLE_NAME, NUM_ROWS, STATUS
                      FROM dba_tables
                      WHERE OWNER = 'AP' AND NUM_ROWS != 0
                       --TABLE_NAME = 'AP_SUPPLIERS'