Skip to Main Content

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 char to number

user585481May 11 2012 — edited May 11 2012
Hi All,

I have data in a column like " *1*2*2* " this I want to multiply and convert into a number that is the result should be 4, how to do this please help me.


Regards

Tulasi,

Edited by: user585481 on May 11, 2012 12:31 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2012
Added on May 11 2012
15 comments
523 views