Converting between Numbers
From: Mark Sminkey <sminkeyk_at_interramp.com>
Date: 1996/02/22
Message-ID: <4giu92$jri_at_dlsn31.dal.mobil.com>#1/1
....
FIELD1 NUMBER(9,5) TABLE Y
....
FIELD1 NUMBER(7,5) The following:
Date: 1996/02/22
Message-ID: <4giu92$jri_at_dlsn31.dal.mobil.com>#1/1
Question:
We have a table with a field defined as NUMBER(9,5). We would like to load this data into another table with a field defined as NUMBER(7,5).
e.g.
TABLE X
....
FIELD1 NUMBER(9,5) TABLE Y
....
FIELD1 NUMBER(7,5) The following:
INSERT INTO TABLE Y
SELECT ...., TO_NUMBER(TO_CHAR(FIELD1,'99.99999'))
FROM TABLE X;
results in a ORA-01722 Invalid Number error after approxiamtely
10,000 rows.
Has anyone ever done something like this and if so how?
Thanks in advance.
Mark Sminkey
sminkeyk_at_interramp.com
Received on Thu Feb 22 1996 - 00:00:00 CET