Extraer la cantidad de registros de una tabla en Oracle

Para extraer la información de que cantidad de registros tiene una tabla en la base de datos Oracle se debe utilizar la siguiente consulta:

SELECT table_name
FROM all_Tables
WHERE owner = '&usuario' and num_rows=0;

Esta retornará todas las tablas con cero(0) registros

This entry was posted on jueves, abril 26th, 2012 at 10:29 and is filed under Base de Datos, Desarrollo, Oracle. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.