convert varchar2 datatype to number data type
849776Jun 14 2011 — edited Jun 14 2011how to convert varchar2 data type to number datatype.
my data looks like
create table a(
col1 varchar2(50)
col2 varchar2(500);
insert into a (col1,col2) values ('1234','2345');
select cast(to_number(col1) as number(19)) column1 from a;
iam getting invalid number error
i need to create a table with same columns with data types as number(19)
can any one help me
Thanks,