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!

Leading zeroes with number function

AzamshareefAug 6 2014 — edited Aug 6 2014

Hi Friends,

How to append zeroes before any number with to_number function?

For Example....

select to_number('009015','009999') Col from dual

Above query is displaying result as

Col

==============

9015

But i want to display as

Col

==============

                 009015

In the result number should in number format but NOT IN VARCHAR format...
This post has been answered by Manik on Aug 6 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2014
Added on Aug 6 2014
16 comments
5,221 views