in European notation, the , is used where Americans use a . and vice
versa. makes for interesting reading of white papers but the replace
statement below will distort the data being entered
- Rick_Cale_at_teamhealth.com wrote:
>
>
>
>
> INSERT INTO new_table(price)
> SELECT REPLACE(price, ',' ,'.')
> FROM old_table;
>
> Rick
>
>
>
>
> Mladen Gogala
>
> <mladen_at_wangtradi To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> ng.com> cc:
>
> Sent by: Subject: Re: Datatype
> conversions
> ml-errors_at_fatcity
>
> .com
>
>
>
>
>
> 11/03/2003 08:54
>
> AM
>
> Please respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Can you re-post this question several more times? We didn't get it
> yet.
> Thanks in advance for your understanding.
>
> On 11/03/2003 07:29:40 AM, 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
> > easiest do this sql statement?
> >
> > In the varchar2(30) field PRICE , table1 it looks like this
> >
> > PRICE
> >
> > 12,50
> > 37,50
> >
> >
> > The datype in table 2 is for that field NUMBER(7,2)
> >
> >
> > 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
>
>
>
> Note:
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any
> mistransmission. If
> you receive this message in error, please immediately delete it and
> all
> copies of it from your system, destroy any hard copies of it and
> notify the
> sender. You must not, directly or indirectly, use, disclose,
> distribute,
> print, or copy any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries each reserve
> the
> right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual
> sender,
> except where the message states otherwise and the sender is
> authorized to
> state them to be the views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.com
>
> 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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Rick_Cale_at_teamhealth.com
>
> 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).
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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 - 08:39:39 CST
