
If the specified number is not an integer, Oracle Database will round it to an integer. Returns the hexadecimal value of the specified number of digits. Returns a value multiplied by 10 n and if necessary, round it up. The current value of the NLS_DUAL_CURRENCY parameter. Returns in the specified position the defoult currency symbol. The text minimum number format model returns the smallest number of characters possible. Returns value with a leading or trailing minus (-) or plus (+) sign. Returns a value as Roman numerals in lowercase. Returns a value as Roman numerals in uppercase. Returns positive value with a leading and trailing blank. Returns positive value with a trailing blank. Returns negative value with a trailing minus (-) sign. Format element for Oracle currency formatting. Default currency value is set in the NLS_CURRENCY parameter. Returns in the specified position the local currency symbol. You can specify multiple group separators in a number format model. The defoult value is set in the NLS_NUMERIC_CHARACTER parameter. Returns in the specified position the group separator. Returns a value without blanks (leading and trailing). Returns in the specified position the decimal character, which is the current value of the NLS_NUMERIC_CHARACTER parameter. Default currency value is set in the NLS_ISO_CURRENCY parameter. Returns in the specified position the ISO currency symbol. Returns blanks for the integer part of a fixed point number when the integer part is zero. Returns value with the specified number of digits with a leading space if positive or with a leading minus if negative.

Returns a period in the specified position. Returns a comma in the specified position it is possible to specify multiple commas. Here you will find list of Oracle Number Format elements: Format element
