Home » SQL & PL/SQL » SQL & PL/SQL » storing a negative numerical value in a field of data type numeric
storing a negative numerical value in a field of data type numeric [message #35979] Sun, 28 October 2001 16:41 Go to next message
Laxsun
Messages: 10
Registered: October 2001
Junior Member
Can I store a negative numerical value (with - sign) in a table field of type numeric, if so how?

----------------------------------------------------------------------

Report message to a moderator

Re: storing a negative numerical value in a field of data type numeric [message #35991 is a reply to message #35979] Mon, 29 October 2001 07:14 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
insert into t (col1) values (-1);

----------------------------------------------------------------------

Report message to a moderator

Re: storing a negative numerical value in a field of data type numeric [message #35994 is a reply to message #35991] Mon, 29 October 2001 08:04 Go to previous message
Laxsun
Messages: 10
Registered: October 2001
Junior Member
Sorry Tod, for asking this silly question,
because I got some problem in loading data
from text file to oracle database using
sql loader. I thought this could be the problem.
The proble is that the number contains "," in it.
Finally I realised that the proble is not with
"-" sign. Yes it is storing the negative values.

I waisted your valuable time.

Thank
Laxsun.

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: updating a huge database
Next Topic: Alter a populated table to add a not null field.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 15:08:37 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.