Re: SQL LOADER and datatype float
From: <brandtner2000_at_gmx.de>
Date: 13 Mar 2005 13:19:09 -0800
Message-ID: <e79eebf1.0503131319.277f67ac_at_posting.google.com>
Date: 13 Mar 2005 13:19:09 -0800
Message-ID: <e79eebf1.0503131319.277f67ac_at_posting.google.com>
you have to try
TO_NUMBER(TO_CHAR(:x, '999.999EEEE'),'999.999EEEE')
This should be work. Received on Sun Mar 13 2005 - 22:19:09 CET