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!

Formatting number with comma separation, NO TO_CHAR

611859Jun 11 2008 — edited Jun 11 2008
Can somebody suggest me how a number can be displayed using comma separation without using TO-CHAR function.

NUMBER 3455678.00 should be displayed as 3,455,678.00, still preserve the type NUMBER

Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2008
Added on Jun 11 2008
9 comments
23,694 views