| Sql [message #853] |
Fri, 08 March 2002 07:28  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
