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!
Hi team ,
need your help ,I am using oracle 11G .
My phone field is of varchar2 type and it is showing data on below format .
81668798343000000000000
I wanted to remove all unwanted zeroes.
result should be 816687983430
Please help me here