Skip to Main Content
Forums

APEX

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!

Simple report column formatting - number to character, right justified

garywickeAug 10 2011 — edited Aug 10 2011
Greetings

Environment: APEX 3.2.1.00.10 on Oracle EE 11.0.1 on AIX on Wednesday :-)

I have created a simple interactive report based on a SQL statement. One of the columns is a NUMBER data type that I would like to appear formatted as '999,990' and right justified.

In SQL I was successful by simply doing an LPAD(TO_CHAR( <number column>, '999,990'), 10)

This doesn't seem to work when I use that syntax in my SQL query in APEX and I can't seem to find a place to format the data in the report definition page.

Does it have something to do with APEX using HTML cells or is there another trick?

Any assistance is greatly appreciated!!!

Thanks!

-gary
This post has been answered by d_wilhelm on Aug 10 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2011
Added on Aug 10 2011
#apex-discussions
2 comments
182 views