TO_NUMBER converts char, a value of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype containing a number in the format specified by the optional format model fmt, to a value of NUMBER datatype. Examples The following example converts character string data into a number: UPDATE employees SET salary = salary + TO_NUMBER(’100.00’, ’9G999D99’) WHERE last_name = ’Perkins’; Note: This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion. Please refer to "Datatype Comparison Rules" on TO_NUMBER ( char, fmt,’ nlsparam ’)
Note: sun.tools.javac.Main has been deprecated. /jysw_infoettj.jsp:87: Method to_Number(java.lang.String) not found in class _jysw_0infoettj__jsp. numanounced = to_Number(strstr,'9D99'); ^ 1 error, 1 warning
datatype containing a number in the format specified by the optional format model
fmt, to a value of NUMBER datatype.
Examples
The following example converts character string data into a number:
UPDATE employees SET salary = salary + TO_NUMBER(’100.00’, ’9G999D99’)
WHERE last_name = ’Perkins’;
Note: This function does not support CLOB data directly.
However, CLOBs can be passed in as arguments through implicit
data conversion. Please refer to "Datatype Comparison Rules" on
TO_NUMBER ( char, fmt,’ nlsparam ’)
/jysw_infoettj.jsp:87: Method to_Number(java.lang.String) not found in
class _jysw_0infoettj__jsp.
numanounced = to_Number(strstr,'9D99');
^
1 error, 1 warning
我在jsp中用这个函数,怎么说没有找到这个函数啊?用to_number()也试过。