Re: SQL Help

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: 2000/05/30
Message-ID: <PVUY4.3176$fq2.369326@nnrp4.clara.net>#1/1

Colin Caie wrote in message <392E32FC.C6C557C6_at_sqf.hp.com>...
>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'.

"select BYTES from dba_extents" does the same thing.

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.

Received on Tue May 30 2000 - 00:00:00 CDT