I believe the data types in Oracle are what they are. For example, there isn’t even a “boolean” type available. So, when you need something else, a string is probably your best option (and is what IFS uses to model boolean fields with “TRUE” and “FALSE” in the FndBoolean enumeration).

The TO_CHAR() function should be able to translate a Number field into anything you wish and present it as text. Here is a decent look-up page of all the formatting masks you can use, so it should be a good start:

https://www.oradev.com/oracle_number_format.html

And Oracle’s more “official” page on TO_CHAR():

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions181.htm

Good luck!

Joe Kaufman

Thank you @sutekh137 ,

I solved my case using to_char(30000000,'FM999G999G999G999') ;

That looks great! Nice work!

Thanks,

Joe Kaufman