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
Kishore
Messages: 45
Registered: September 2000
Member
Hi,
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,
Kishore

Report message to a moderator

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

Report message to a moderator

Previous Topic: Failure to create database link
Next Topic: hi suresh .. data base link
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 22 10:12:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.