Re: Bytes Used by Various Data Types

From: Richard Close <spammers_at_die.die.die>
Date: 1997/06/20
Message-ID: <01bc7dc6$0cb3fc50$d79e989e@logres>#1/1

Jim,

you want the VSIZE function - e.g.
select vsize(SYSDATE) from DUAL;
(DUMP(columnname) will show you the byte values as well.

Richard Close
richard@ logres. demon . co. uk

Jim Privett <jim.privett_at_lmco.com> wrote in article <33A7EEBC.3C6D_at_lmco.com>...
> Hi. We have a request for sizing data that will
> eventually be put into an Oracle database, and are
> wondering if someone could point us at information
> as to how many bytes in physical storage are taken
> up by the various data types (DATE, NUMBER, etc.).
>
> Thanks very much in advance for any replies.
>
> - Jim Privett, jim.privett_at_lmco.com -
>
Received on Fri Jun 20 1997 - 00:00:00 CDT