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'

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete