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).
