Home » SQL & PL/SQL » SQL & PL/SQL » Sql
Sql [message #853] Fri, 08 March 2002 07:28 Go to next message
Arikrishnan S
Messages: 1
Registered: March 2002
Junior Member
I want sql statment to get result as below.

Table Name: No.Of Rows.

If any one could give solution Pls send

Thanks
Arikrishnan S
Re: Sql [message #856 is a reply to message #853] Fri, 08 March 2002 08:19 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
save this script in a file and execute (say cnt.sql)
set term off
set feed off
set pagesize 0
set newpage none
set echo off
spool table_count.sql
select 'PROMPT TABLE : '||table_name||chr(10)||'select ''Number of records '' ||count(*) from '||table_name||';'
from user_tables;
spool off
set term on
@table_count.sql

SQl>@cnt.sql
Previous Topic: Recompile everything using a view?
Next Topic: Utl_file package
Goto Forum:
  


Current Time: Wed Oct 27 05:05:14 CDT 2021