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!

character to number conversion

Lucy DiscoverApr 11 2008 — edited Apr 11 2008
I have column varchar2(255) format which has all number stored init . I want update another column with the same values but stored as numbers . What should I do.

example :
ID_NO varchar2(255) example value :2593
should be copied to
ID_NO1 number example value :2593 should be stored here as number.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Apr 11 2008
9 comments
663 views