Re: domain type question/mystery

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Tue, 4 Nov 2003 08:59:16 +0000 (UTC)
Message-ID: <bo7pp4$m1l$1@srv.cyf-kr.edu.pl>

old dirtbeard <dirtbeard_at_pacbell.net> wrote:

> Now I'm more confused -- I always thought that
> number was limited to 38 digit precision, but in
> 9i I can insert 126 digit numbers:

You can insert, but you still have 38 digit precision. Try:

SELECT to_char(col1,''99.9999999999999999999999999999999999999999EEEE') 

from test_long;

Internal representation of the NUMBER datatype: http://www.ixora.com.au/notes/number_representation.htm

Greetings,
LW Received on Tue Nov 04 2003 - 02:59:16 CST