Number of records in table

User can find out the number of record in table

SELECT table_name,
       TO_NUMBER(EXTRACTVALUE (
                    xmltype(DBMS_XMLGEN.getxml (
                               'select count(*) c from ' || table_name)),
                    '/ROWSET/ROW/C'))
          COUNT
  FROM user_tables
 WHERE table_name LIKE '&table_name' 
-- table_name like 'GL%'

Number of records in table

Tags