ORACLE函数TO_CHAR以及数字转换格式(国外英文资料).doc

ORACLE函数TO_CHAR以及数字转换格式 This function turns the parameter N into a value of the VARCHAR2 type. N could be NUMBER, BINARY_FLOAT, or BINARY_DOUBLE. If you dont have a format, then the function converts N into a VARCHAR2 string that represents N. Format reference: The serial number Format simplified example 1, (comma) 9999999 comma, generally appears in micrometer level, used as a grouping symbols. If you need you can also as very, percentile, can appear N times, depending on the size of the figure. The abnormal example is to_char (1234, 9, 9, 9). Note: only appear in the integer section. 2. (dot) 99.99 period, do not read as end, end is a circle, some good can only appear in the decimal point corresponding place. Can only appear once. To_char (1234.34, 9, 9, 9, 9.99) Note: only in one place is the original data point location 3 $(dollar sign) $999.99. You can actually put it anywhere (under 10G) To_char (1234.34, 9, 9, 9, 9. $99) Note: only once. 4 0 (0) 0999.99 Zero. Return the corresponding character in the corresponding location, if not, if not, fill in 0. To_char (0.34, 9, 9, 9, 0. $99) = $0.34; To_char (1234, 9999.00) = 1234.00; Note: this is a mandatory symbol, the corresponding bits are not, and they are filled with o, which is a lot of different places 5, 9 999.99 In the decimal place, the representation is converted to the corresponding character, if it is not represented by 0. In the integer bits, there is no corresponding unfilled character. To_char (123, 999.99) = 123.00; TO_CHAR (123, 99999.9) = 123.0; Note: for 0 and 9, if the number of formats is not as large as the number of digits, it will return #. For example, to_char (12345, 9999) = # # # 6 B (space character) B999 has no other special effects, adding a space at the front of the integer section to appear in any location. S | | TO_CHAR (1234, 99B99) = S 1234; Note: only in the integer area. The 7 C (international monetary symbol) C9999 returns an ISO currency symbol in a specific location (the value