Yes but how should I write the sql statement when to make the incoming varchar2 field into a number?
Roland Mladen Gogala <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> .net> cc: Sent by: Subject: Re: Question about datatypes [EMAIL PROTECTED] .com 2003-11-03 13:19 Please respond to ORACLE-L 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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).