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!

TO_CHAR strange behaviour with format model

Hi all

I'm using Oracle Database 19c and have noticed something strange:

select to_char(1234, '00000') from dual

returns ‘ 01234’ with leading blank space.

This post has been answered by Gerrit van der Linden on Feb 19 2026
Jump to Answer
Comments
Post Details
Added 2 days ago
2 comments
59 views