Assuming your purpose is to get the approximate number of rows in each
table, then you could simply do:

select TABLE_NAME, NUM_ROWS
from USER_TABLES
where TABLE_NAME like 'GL%';

This query assumes that stats are up-to-date. But they should be anyway.

-----Original Message-----
From: bralston
[mailto:oracledba-ezmlmshield-x79985453.[Email address protected]
Sent: Tuesday, May 31, 2005 3:34 PM
To: LazyDBA Discussion
Subject: sql help

I have what is probably a basic sql question. I am pulling a list of
tables
that have a name like 'GL%'. I am then wanting to pull a count on each
table
in the same clause to get output like this :

Table_name Count

GLMASTER 100
GLNAME 94
GLTRANS 500


Any ideas ???

Brad

This e-mail contains information that may be proprietary in nature or
otherwise protected by law from disclosure, and is intended only for the
addressee(s) named above. If you are not the addresee, or the person
responsible for delivering this to the addressee(s), you are hereby
notified that reading, copying or distributing this e-mail is
prohibited.

If you have received this e-mail in error, please contact the sender of
this e-mail immediately.




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


IMPORTANT NOTICE:
This message may contain confidential information. If you have received this e-mail in error, do not use, copy or distribute it. Do not open any attachments. Delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.


Oracle LazyDBA home page