Syntax
Purpose
TO_NUMBER converts char, a value of CHAR or VARCHAR2 datatype containing a
number in the format specified by the optional format model fmt, to a value of
NUMBER datatype.
Examples
UPDATE emp SET sal = sal +
TO_NUMBER(’100.00’, ’9G999D99’)
WHERE ename = ’BLAKE’;
The ’ nlsparams’ string in this function has the same purpose as it does in the TO_
CHAR function for number conversions.
TO_NUMBER ( char
, fmt
, ’ nlsparam ’
)
Purpose
TO_NUMBER converts char, a value of CHAR or VARCHAR2 datatype containing a
number in the format specified by the optional format model fmt, to a value of
NUMBER datatype.
Examples
UPDATE emp SET sal = sal +
TO_NUMBER(’100.00’, ’9G999D99’)
WHERE ename = ’BLAKE’;
The ’ nlsparams’ string in this function has the same purpose as it does in the TO_
CHAR function for number conversions.
TO_NUMBER ( char
, fmt
, ’ nlsparam ’
)
解决方案 »
- 重复记录保留一条的初级问题
- 怎样利用pl/sql developer 生成已经存在的表的建表sql
- 插入大对象的SQL语句怎么写?
- oracle存储过程调用存储过程的问题 ORA-00947
- 如何获取执行procedure所消耗的时间??(最好在sqlplus下)
- ★★★★★【200分求解OCI的一些问题】★★★★
- 关于ORACLE存储过程,对于你们应该很简单
- 怎样随机选出符合条件的记录?
- 奇怪在DELPHI中调用一个存储过程发生ORA-12571错误
- 关于sqlpulsworksheet的问题
- 有关oracle中约束类型的问题?
- 如果客户端程序不进行任何操作,能否在数据库中设置一个值将会话断开
to_char
to_date这些都是类型转换函数。