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 ’
)
解决方案 »
- oracle 触发器
- oracle 10g oem web访问isql*plus打开连接时候总是报错!
- 关于group by
- windows 7 64位操作系统,数据库为oralce 11g,vs2010不能连接上
- oracle 9i安装
- oracle developer的连接问题
- 被逼的没办法了,虽然对Orcale一无所知,也要问一下,如果误更新了记录,能不能还原到更新前的状态
- 急,求助,有关ORACLE字符集的问题
- 在8i/Win2000中如何建立OMS(ORACLE Management Server)?
- 如何设置db占用的内存大小?
- 有关oracle中约束类型的问题?
- 如果客户端程序不进行任何操作,能否在数据库中设置一个值将会话断开
to_char
to_date这些都是类型转换函数。