Select 'Select '''||table_name||' : ''||count(*) from '||table_name||';',
to_char(sysdate, 'YYYYMMDDHH24MISS') d, user u
from user_tables
order by table_name
To Get all Tables in Oracle With count
To get all Tables in Oracle With count.
Loading
To get all Tables in Oracle With count.