want to count records for all the tables in a schema. For example,
SQL> select table_name from user_tables order by table_name;
3 rows selected.
SQL> select count(1) from t1;
Can one complex query be written to get the records per table? The result is