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!

LPad Function is not cooperating

804017Jul 26 2011 — edited Jul 26 2011

I am working in APEX and the LPad function is not cooperating this time.

I am looking for a way to LPAD spaces into the SUM(LineItems) column. I can get characters to pad, but not just spaces. I have used the following functions and combination of functions and still no luck.

LPad(SUM(LineItems),7,' ')

LPad(TO_CHAR(SUM(LineItems)), 7,)

LPad(TO_CHAR(SUM(LineItems)), 7, ' ')

LPad(CAST(SUM(LineItems)AS VARCHAR2(10)), 7)

LPad(CAST(SUM(LineItems)AS VARCHAR2(10)), 7, ' ')

Any and all suggestions would be appreciated!

-Robert

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 23 2011

Added on Jul 26 2011

#apex-discussions, #html

4 comments

582 views