var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: record count
I have created around 40 tables in a database. Is there a way I can count total records in all the tables at a time instead of doing table by table?
Your help is appreciated.
If you have gathered statistics, and you don't really expect all numbers to be accurate, you might try with
Otherwise, create a script in SQL*Plus as
SELECT table_name, num_rows
Now run @count_records.sql at the SQL*Plus prompt.
SET header OFF
SET feedback OFF
SELECT 'SELECT COUNT(*) FROM '||table_name||';' FROM user_tables;