Hello,
I have a Table where the values are stored mostly numbers but one of the value has , in it.Though the field is kept as varchar2 for business purpose the number are stored in it.
I need to exposre even though the field is varchar2 and has , values in it should display in number format.
create table test_number
(
attribute2 varchar2(20));
insert into test_number values ('2,448.50');
insert into test_number values (6000.34);
commit;
select * from test_number;
Can the value which is represented as 2448.50 instead of 2,488.50 when we select from the table
Please need help on this