Bizarre numeric data
From: Graham <graham_at_tecskor.com>
Date: Wed, 27 Jan 1999 16:46:49 -0700
Message-ID: <VzNr2.152$4v1.2875_at_thor.cal.sfl.net>
Hi,
:000001
Date: Wed, 27 Jan 1999 16:46:49 -0700
Message-ID: <VzNr2.152$4v1.2875_at_thor.cal.sfl.net>
Hi,
I have a table in Oracle 7.3.4.0.1 that has a column defined to be NUMBER(12,2). DESC ATABLE ACOLUMN NUMBER(12,2) I have one record where the value of the column is, and I quote, :000001 (notice the ':')
In other words if I say
SELECT ACOLUMN FROM ATABLE WHERE ....
The result I get is
ACOLUMN
:000001
Even better,
SELECT ACOLUMN-1, ACOLUMN+0, ACOLUMN+1 FROM ATABLE WHERE ... results in
999999 1000000 1000001
Finally
SELECT ACOLUMN/1 FROM ATABLE WHERE ...
ORA-01426 numeric overflow
Whats up? Received on Thu Jan 28 1999 - 00:46:49 CET