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!

mypriceformat feature clarification

Sruthi TamiriAug 22 2014 — edited Aug 22 2014

Hi Team,

Could you help me on this scenario

select ltrim(to_char('1877','999G990D99')) x from dual

union all

select ltrim(to_char('1876','fm999G990D9999')) x from dual;

The out will appear as

1,877.00 for format 999G990D99

1,876. for format fm999G990D9999

As currently we are updated fm format, how we can ignore period operator in end, if the value entered as numeric only.

Regards,

Sruthitamiri

This post has been answered by fac586 on Aug 22 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2014

Added on Aug 22 2014

#apex-discussions

5 comments

1,447 views