Converts a number to a spelling statement.

Convert a number to a spelling statement software environment Windows Server 2008 R2Oracle 11g Release 1 (11.1) Demonstrate converting a number to an English spelling SQL> select decode (sign (& num ), -1, 'negative ', 0, 'zero', NULL) | 2 decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J'), 'jsp ') 3 from dual; input num value: 1 original value 1: select decode (sign (& num),-1, 'negative ', 0, 'zero', NULL) | new value: 1: select decode (sign (1 ), -1, 'negative ', 0, 'zero', NULL) | input num value: 1 input num value: 1 Original Value 2: decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J'), 'jsp ') New Value 2: decode (sign (abs (1), + 1, to_char (to_date (abs (1), 'J'), 'jsp ')) DEC --- One SQL> select decode (sign (& num),-1, 'negative ', 0, 'zero', NULL) | 2 decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J'), 'jsp ')) 3 from dual; input num value: 5 original value 1: select decode (sign (& num),-1, 'negative ', 0, 'zero', NULL) | new value 1: select decode (sign (5),-1, 'negative ', 0, 'zero', NULL) | input num value: 5 Input num value: 5 original value 2: decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J '), 'jsp ') New Value 2: decode (sign (abs (5), + 1, to_char (to_date (abs (5), 'J '), 'jsp ') DECO ---- Five SQL> select decode (sign (& num),-1, 'negative', 0, 'zero ', NULL) | 2 decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J'), 'jsp ')) 3 from dual; input num value: 25 original value 1: select decode (sign (& num),-1, 'negative ', 0, 'zero', NULL) | new value 1: select decode (sign (25),-1, 'negative ', 0, 'zero', NULL) | input num value: 25 input num value: 25 Original Value 2: decode (sign (abs (& num), + 1, to_char (to_date (abs (& num), 'J '), 'jsp ') New Value 2: decode (sign (abs (25), + 1, to_char (to_date (abs (25), 'J '), 'jsp ') DECODE (SIGN ----------- Twenty-Five SQL>