Re: Number of bytes used by number data type

See notes on

    http://www.jlcomp.demon.co.uk/faq/num_size.html

There's also a note on the site (though not in the FAQ) about reading internal formats and working out what number it represents.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now available One-day tutorials:
  Cost Based Optimisation
  Trouble-shooting and Tuning
  Indexing Strategies

(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______April 8th
____UK_______April 22nd

____Denmark May 21-23rd

____USA_(FL)_May 2nd

Next dates for the 3-day seminar:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____UK_(Manchester)_May
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- From: <Rishi.Jain_at_VerizonWireless.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 19 March 2003 22:18 Subject: Number of bytes used by number data type

> Guru's
>
> I want to find out the exact space occupied by a number field. E.g I
want to
> find out the space occupied by a field
> NUMBER(7,2). I know oracle has an alogorithm to figure that out .
>
> A quick response would be highly appreciated
Received on Thu Mar 20 2003 - 02:13:44 CST