Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Script for total number of rows
Hi,
I am a beginner in Oracle.I need a script that will show the total number of rows in all the tables in a specific schema.I can select the "NUM_ROWS" along with the table_names from user_tables but for that I have to run "Analyze table t compute statistics" for each table and I want to avoid doing that. Is there any way I can write a PL/SQL script that I can store in the database which will retrieve the information I want...
Thanks,
Pinaki
Received on Wed Apr 17 2002 - 13:12:04 CDT