![]() This is the format that will be used to convert string1 to a number. string1 The string that will be converted to a number. ![]() However, CLOBs can be passed in as arguments through implicit data conversion. The syntax for the TONUMBER function in Oracle/PLSQL is: TONUMBER ( string1, formatmask, nlslanguage ) Parameters or Arguments. ![]() This function does not support CLOB data directly. Refer to TO_CHAR (number) for more information. The Oracle/PLSQL TONUMBER function converts a string to a number. The 'nlsparam' argument in this function has the same purpose as it does in the TO_CHAR function for number conversions. Refer to " Format Models" for information on number formats. If you specify an expr of BINARY_FLOAT or BINARY_DOUBLE data type, then you cannot specify a format model because a float can be interpreted only by its internal representation. If you specify an expr of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type, then you can optionally specify the format model fmt. Otherwise, the function converts expr to a NUMBER value. If expr evaluates to null, then the function returns null. If expr is NUMBER, then the function returns expr. TO_NUMBER converts expr to a value of NUMBER data type.Įxpr can be any expression that evaluates to a character string of type CHAR, VARCHAR2, NCHAR, or NVARCHAR2, a numeric value of type NUMBER, BINARY_FLOAT, or BINARY_DOUBLE, or null.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |