to_clob():
The TO_CLOB function converts NCLOB values in a LOB column or other character
strings to CLOB values. char can be any of the datatypes CHAR, VARCHAR2, NCHAR,
NVARCHAR2, CLOB, or NCLOB. Oracle executes this function by converting the
underlying LOB data from the national character set to the database character set.UPDATE PRINT_MEDIA
SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);
The TO_CLOB function converts NCLOB values in a LOB column or other character
strings to CLOB values. char can be any of the datatypes CHAR, VARCHAR2, NCHAR,
NVARCHAR2, CLOB, or NCLOB. Oracle executes this function by converting the
underlying LOB data from the national character set to the database character set.UPDATE PRINT_MEDIA
SET AD_FINALTEXT = TO_CLOB (AD_FLTEXTN);
解决方案 »
- oracle10g10.2.0.1.0类型长度大于最大值
- Oracle中的单引号和双引号
- 如何实现查询语句中减1的操作,具体请进
- 如何把一个永久表空间变为临时表空间?
- T-SQL到PL/SQL:T-SQL中实现范围选择的case语句在PL/SQL中该怎么写
- 登陆oracle9i的问题
- 用MS SQLSERVER DTS 将数据导入ORACLE中为何先要将表名改为大写?
- 表名称要改,怎么不丢数据下完成?
- win2000下oracle8i在enterprise manager 中备份数据老是报错,提示验证错误。
- 关于oracle中Case 的使用方法??????????????急急急急急急急!!!!!!!!!!!!!
- 插入字符串时出现错误:oracle ora-01704 (字符串过长),如何解决?
- 如何拼合不同记录行的字符串?
AD_FINALTEXT 是什么?
AD_FLTEXTN 又是什么?这样做的结果是什么?