For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
I have column datatype varchar2
i need to change it to number
the value for that column is .17782,.20704,.24128
how can i convert this to number
SELECT TO_NUMBER(COALESCE('.17782,.20704,.24128','1'))
from dual;
this through invalid number error