Re: SELECT Statement help required

From: N Prabhakar <n_prabhakar_at_post1.com>
Date: 1997/07/31
Message-ID: <01bc9d72$aae18430$725118d2@sin00119>#1/1

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
>
Received on Thu Jul 31 1997 - 00:00:00 CDT