Trigger using TO_NUMBER function would be the first thing that comes to mind.
I have designs like that, which are used for parsing so calld "Bloomberg
files". Those files contain strings like "N.A.", "-",|| ('|' is the field
delimiter) and all of those strings mean "NULL". Also, stock split ratio can
be described as: "1:2", "1/2", "2 for 1", "0.5", which has to be mapped to a
number field. I'm using perl to parse the input files and I'm using crontab to
schedule perl script exectuion.
On 2003.11.03 05:14, roland.skoldblom_at_ica.se wrote:
> Hallo,
>
> Maybe this sounds simple for all of you, but I have a table with the field
> PRICE and that is with datatype varchar2 I want the data in that field to be
> inserted in another table with field PRICE, but that field has the datatype
> NUMBER. How can I
> deasiest do this sql statement?
>
> I really have to have the Varchar dataype in table1.
>
> Thanks in advance
>
> Roland
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: roland.skoldblom_at_ica.se
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Nov 03 2003 - 06:19:41 CST
