请问如何在Oracle中将值转换成存文本的值?
如题,我是将读取到的值保存在long型的数据中,这段数据里面有类似于insert into QX_NEWS
(v_xwid,
V_FLID,
v_ztid,
v_xwlb,
v_top,
v_dwid,
v_bt,
d_fbdate,
v_sh,
v_nr,
v_manid,
v_lmmanid,
d_lmdt,
N_READCNT)
values
('102',
'0',
'12105',
'951',
'0',
'0',
'fsdf',
to_date('2007-12-13 17:11:56', 'yyyy-MM-dd HH24:mi:ss'),
'0',
dsfsdfs <OBJECT codeBase=http://download.,0,0,0 classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000><PARAM NAME="_cx" VALUE="5080"><PARAM NAME="_cy" VALUE="5080"><PARAM NAME="FlashVars" VALUE=""><PARAM NAME="Movie" VALUE="/UpLoadFile/20071213171151612.swf"><PARAM NAME="Src" VALUE="/UpLoadFile/20071213171151612.swf"><PARAM NAME="WMode" VALUE="Window"><PARAM NAME="Play" VALUE="0"><PARAM NAME="Loop" VALUE="-1"><PARAM NAME="Quality" VALUE="High"><PARAM NAME="SAlign" VALUE=""><PARAM NAME="Menu" VALUE="-1"><PARAM NAME="Base" VALUE=""><PARAM NAME="AllowScriptAccess" VALUE=""><PARAM NAME="Scale" VALUE="ShowAll"><PARAM NAME="DeviceFont" VALUE="0"><PARAM NAME="EmbedMovie" VALUE="0"><PARAM NAME="BGColor" VALUE=""><PARAM NAME="SWRemote" VALUE=""><PARAM NAME="MovieData" VALUE=""><PARAM NAME="SeamlessTabbing" VALUE="1"><PARAM NAME="Profile" VALUE="0"><PARAM NAME="ProfileAddress" VALUE=""><PARAM NAME="ProfilePort" VALUE="0"><PARAM NAME="AllowNetworking" VALUE="all"><PARAM NAME="AllowFullScreen" VALUE="false"> <embed src=' /
UpLoadFile / 20071213171151612.swf ' quality=high pluginspage=' http
:/ / [url]www.[/url] / shockwave / download / index.cgi ?
P1_Prod_Version = ShockwaveFlash ' type='
application / x - shockwave - flash
'>/UpLoadFile/20071213171151612.swf</embed></OBJECT>,
'943',
'943',
to_date('2007-12-13 17:11:56', 'yyyy-MM-dd HH24:mi:ss'),
'0')
其中红色标记的部分总是出错,将我数据中的标点符号也做为ora的符号读取了,我就想把红色部分的值改成纯文本或者字符串内的值,可以实现么?