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 zip code string value into decimals

619359Jan 23 2008 — edited Jan 24 2008
Hi

I would like to convert zip code into decimal value with out losing leading zeros.

Ex: I have zip code called '06095'. When i am trying to converting this string value into decimal value, i am getting 6095. But i am loosing zero before that.

Please help me to resolve this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2008
Added on Jan 23 2008
5 comments
487 views