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.



Oracle LazyDBA home page