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
Hej Roland (Sverige?),
I doubt that. If all the data is number in the varchar2 column, well, you
don't need it to be varchar2.
The easiest solution seems to be:
INSERT INTO newtable SELECT TO_NUMBER(col) FROM oldtable;
Premise: all your data in that column IS number. If you're not sure,
do
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
:
Sent by: Subject: Re: Question about datatypes
[EMAIL PROTECTED
:
Sent by: Subject: Re: Question about
datatypes
[EMAIL PROTECTED