Re: SQL Help

Hi,

in 8i you can just say
 select blocks*(select value from v$parameter where name = 'db_block_size') from dba_extents;

ciao
 Thomas
>
> Hi,
> I would like to perform a query that;
>
> select blocks from dba_extents
>
> then multiplies the blocks by the value produced from;
>
> select value from v$parameter where name = 'db_block_size'.
>
> Can anyone help?.
> --
> Regards,
>
> Colin Caie

--
Thomas Schwickert               Phone: +49 69 - 404 8661
Neckermann Versand AG           Fax:   +49 69 - 404 5561
60386 Frankfurt
Germany


Sent via Deja.com http://www.deja.com/
Before you buy.