Quick select question

From: Robertson Lee - lerobe <lerobe_at_acxiom.co.uk>
Date: Wed, 20 Jun 2001 09:03:35 -0700
Message-ID: <F001.00330669.20010620091710@fatcity.com>

<SPAN

class=625121716-20062001>All,
<SPAN

class=625121716-20062001> 
Anyone know how to
get a list of tablenames and the count of rows in them
<SPAN

class=625121716-20062001> 
<SPAN

class=625121716-20062001>TABLE_NAME    COUNT
<SPAN

class=625121716-20062001>===========   ======
<SPAN

class=625121716-20062001>LEE                        

10
<SPAN

class=625121716-20062001>LEE1                       

25
<SPAN

class=625121716-20062001>LEE2                      
17................etc etc

<SPAN

class=625121716-20062001> 
I know it can be
done if the tables are analyzed and from user_tables but was wanting to know how to do it from sqlplus.
<SPAN

class=625121716-20062001> 
<SPAN

class=625121716-20062001> 
Tru64

<SPAN

class=625121716-20062001>8.0.5.0.0
<SPAN

class=625121716-20062001> 
<SPAN

class=625121716-20062001> 
<SPAN

class=625121716-20062001>TIA
<SPAN

class=625121716-20062001> 
<SPAN

class=625121716-20062001>Lee

 

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Received on Wed Jun 20 2001 - 11:03:35 CDT