Home » SQL & PL/SQL » SQL & PL/SQL » A question about NUMBER datatype
A question about NUMBER datatype [message #18959] Fri, 22 February 2002 18:38 Go to next message
Messages: 45
Registered: September 2000
I am trying to insert a value 1234567.89 into a column of datatype NUMBER(9,3). It's failing with an error that the value is larger than expected. Could you please let me know, why?
Thanks in advance,
Re: A question about NUMBER datatype [message #18960 is a reply to message #18959] Fri, 22 February 2002 18:54 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if u specify number(9,3) as column datatype, oracle allows 6 digit number and 3 digits right to decimal point.

you can insert 123456.789, not 1234567.89
Previous Topic: Failure to create database link
Next Topic: hi suresh .. data base link
Goto Forum:

Current Time: Sun Sep 19 11:33:55 CDT 2021