Number field without specifying the size of it
Petri BRJul 25 2011 — edited Jul 25 2011Hi there.
What happens if I create a number field without specifying the size of it.
I've created a test table, and inserted numbers into it.
CREATE TABLE TEST
(
NUMBER_TEST NUMBER
)
;
It allows until size 40, after that it looses the "precision" of the number after the 40th position.
It allows.........: 1234567890123456789012345678901234567890
It doesnt allow: 12345678901234567890123456789012345678901
That last one became 12345678901234567890123456789012345678900
So, how can I know the maximum of numbers a field can support when I dont specify it?
By the way, I'm using Oracle 9.2.