If the data is really a number ( ie. no alpha characters )
you don't need to do anything, Oracle does an implicit conversion.
insert into my_table_numeric( real_number_column )
select my_stupid_varchar2_col
from I_hope_these_are_all_numeric_table
/
Jared
On Mon, 2003-11-03 at 04:44, [EMAIL PROTECTED] wrote:
>
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
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).
