NUMBER FORMAT MODELS for TO_CHAR#
This table lists the number format elements. You can use any combination of these elements as the format argument of the TO_CHAR function.| Parameter | Example | Explanation |
|---|---|---|
| 9 | ‘9999’ | Number of “9”s determines the length of the returned character |
| 0 | ‘0999’ | Prefixes value with leading zeroes |
| $ | ‘$9999’ | Prefixes value with a dollar sign |
| B | ‘B9999’ | Returns zero value as a blank, instead of as 0 |
| MI | ‘9999MI’ | Returns ‘-‘ after negative values. Note that by default, a space is left in front of any number value converted to character, to allow for the possibility of a negative sign. |
| S | ‘S9999’ | Returns ‘+’ for positive values and ‘-‘ for negative values. |
| PR | ‘9999PR’ | Returns negative values in <angle brackets>. |
| , | ‘9,999’ | Returns a comma in this position (Thousands separator) |
| . | ’99.99’ | Returns a period in this position. (Decimal point) |
| V or v | ‘999V99’ | Returns the value by 10n where n is the number of “9”s after the “V” (implied decimal point) |
| RN or rn | RN | Upper or lowercase Roman numerals (for integers in range 1 ..3999) |
