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!

to_char(number, fmt)

grimrandMay 5 2016 — edited May 5 2016

Hi all


I looked at the sample questions on the certification page for 1z0-051

one example had something like select to_char(1234, '009,999.99') from dual

from looking at the documentation the first 0 means pad leading blanks with 0, but what purpose does the second 0 serve?

Regards

Terry
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2016
Added on May 5 2016
2 comments
577 views