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

ORACLE函数TO_CHAR以及数字转换格式 This function turns the parameter N to a value of type VARCHAR2. N can be NUMBER, BINARY_FLOAT, or BINARY_DOUBLE. If it is not formatted, the function converts N into a VARCHAR2 string that is sufficient to represent N. Format table reference: Serial number Format brief illustration 1, comma,9999999comma, usually appear in thousands, as a group symbol. If you need, you can also be seen as a bit, percentile, which can appear N times, depending on the size of the number The example of metamorphosis is to_char (1234,9,9,9,9) Note: only in the integer part 2. (DOT)99.99dot,