Ok, I know this is an easy one but I am having a serious brain fart.
I created a script that does a count(1) on all tables for a schema. Ex...
select count(1) from jeff.myhero;
select count(1) from jeff.palforlife;
Ect...
How do I get this to display the table_name, all this displays is count(1)
100 rows
but no table name.
I played with the SQL* plus, verify, echo, termout, serveroutput but i got nada, suggestions?
Thanks;
MH