Re: Newbie Query Help

You can try with:

select rownum, TABLE_name from ALL_TABLES where owner='XXXX'

I built it with SQL*Plus 8.1.6.0.0

bye,

        Roby

SKELTON.B_at_MELLON.COM (Brian) wrote in message news:<6fb94e82.0111270746.5e9c0ac9_at_posting.google.com>...
> I wonder if anyone can help me I have a bunch of tables that I need
> to get a row count the list of tables is provided dynamically by the
> Query
>
> select TABLE_name from ALL_TABLES where owner='XXXX'
>
> Can I build a query to get the row count of the tables provided by
> this
> or do I need to use a PL/SQL.
>
> I am unable to use the catalogue stats NUM_ROWS as I don't know how
> reliable they are at the moment.
>
> Any comments/ideas would be greatfully appreciated.
Received on Wed Nov 28 2001 - 03:59:10 CST