Skip to Main Content
Forums

SQL & PL/SQL

Announcement

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!

convert string(varchar) to number

528400May 30 2007 — edited May 30 2007
Hi ,

How can we convert any varchar2 value to number.

e.g. validity column is of varchar2 type and contains records like 002, 01, 1 -999,-111 etc

I have to convert this into numbers and make some calculations.

Thanks,

Amitesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2007
Added on May 30 2007
2 comments
4,145 views