Invalid Number
497041Apr 14 2007 — edited Apr 14 2007I have a table test having a field hs of varchar2 data type
create table test
(h1 varchar2(20))
h2 varchar2(20));
The field has 3 rows
12,13
13,14
15,16
Now I want to create a table from the above table as follows:
create table test1 as select to_number(h1) + to_number(h2) from test
The above statement gives the following error:
----Invalid Number.
Please help