You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

how to use format mask in rtf template

Received Response
34
Views
3
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 3 comments

Summary

how to use format mask in rtf template

Content

Hi All,

 

How to use this code in rtf template?

 

SELECT TO_CHAR (TO_NUMBER (LINE_AMOUNT, 'FM9G999G999G999G990D99999'),'FM9G999G999G999G990D00000') AS formatted_value

  FROM DUAL

 

Thank you,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!