toDecimal

Arguments

1. Input element.
2. Optional: Scale of the decimal as a string or numeric data type.
3. Optional: Rounding mode for the decimal. It can be the name of the mode as a string or the corresponding integer constant:
   • "UP" or 0
   • "DOWN" or 1
   • "CEILING" or 2
   • "FLOOR" or 3
   • "HALF_UP" or 4
   • "HALF_DOWN" or 5
   • "HALF_EVEN" or 6
   • "UNNECESSARY" or 7
   The default value is "FLOOR". For more information about rounding modes, see the Oracle documentation.

Examples