10 October 2011

Know how many records there is inside a table using Sql without using COUNT

SELECT T.OWNER
      ,T.TABLE_NAME
      ,T.NUM_ROWS
  FROM ALL_TABLES T
 WHERE T.OWNER = 'RHOWN'
   AND T.TABLE_NAME IN ('FUNCIONARIO_MOVIMENTOS_HIST')

0 comentários: