Re: SELECT Statement help required

N Prabhakar wrote:
>
> Hello there,
>
> You can analyse ('compute statistics') each of the tables in your database,
> then issue a query against DBA_TABLES / ALL_TABLES / USER_TABLES. This
> process may take some time.
>
> Alternatively, you can write a dynamic sql using DBMS_SQL package
> (available from Oracle 7.2) onwards.
>
> Good luck
>
> N.Prabhakar
>
> James Petts <jpetts_at_celltech.co.uk> wrote in article
> <33D7125D.7DE3_at_celltech.co.uk>...
> > I'm trying to write a SELECT statement which will return the
> > number of rows in each of a set of tables selected by owner
> > from DBA_TABLES.
> >
> > Any ideas?
> > --
> > James "I'd rather fall off Ilustrada than ride any other horse" Petts
> >

How about:

 SELECT table_name, num_rows
 FROM dba_tables
 WHERE owner = <bla>; Received on Wed Aug 06 1997 - 00:00:00 CDT