Name
format_number — format a numeric value using an XSLT-style picture string
Synopsis
varchar format_number(
|
in number any, |
in format varchar); |
Description
format_number renders number
as a string according to the picture string format.
The picture-string syntax follows the XSLT 1.0
format-number() function and supports the digit
placeholders 0 and #, the decimal
point ., the grouping separator ,,
the percent % and per-mille ‰
indicators, currency symbol ¤, sign separator
;, and minus sign -.
The input number is converted to an internal
numeric value using the maximum supported precision and scale; an SQL
error is signalled if conversion fails.
Examples
Example 24.127. Simple Examples
SQL> select format_number (1234567.89, '#,##0.00');
SQL> select format_number (0.4567, '0.00%');