Friday, February 3, 2012

To Get all Tables in Oracle With count


Select 'Select '''||table_name||' : ''||count(*) from '||table_name||';',
    to_char(sysdate, 'YYYYMMDDHH24MISS') d, user u
from user_tables
order by table_name


No comments :

Post a Comment