如何将双引号改成单引号 就是如何把中间insert语句里的双引号改成单引号。我最后执行insert 的时候不可能带着双引号执行啊 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select replace('INSERT into t_sale_h(vc_saleno,vc_depid,vc_posno,dt_begindate,dt_enddate,vc_shroff,vc_claimman,vc_discountman,vc_changeman,vc_giftman,vc_reserve1,vc_reserve1type,nu_amount,nu_realamt,nu_disamt,vc_memcardno, nu_backstatus,vc_istrans) values ("200407308710050197","002040","871005","2004-07-30 09:05:44.030","2004-07-30 09:09:03.030","8710001","null","8710001","8710001","null","null","null",801.800000,771.800000,26.000000,"000173857",0,"0")'','"','''') "result" from dual;这个肯定可以 请教一个ORACLE游标的问题 散分庆祝:转正和学习使用ORACLE2个月 不同数据库间的导入导出 oracle安装问题 求助高手,一个关于游标判断某列值为空的语句.在线等/ 求一个SQL,跟INDEX有关的 bt设计给的难题(SQL) oracle牛牛们救命啊! 一个关于 Oracle Enterprise Manager 的问题 请问怎么才能看到下面地址的帖子? 急!!!各位老大,怎样查看和修改Oracle的连接数量? 关于触发器的问题(在一个表中检索符合要求的数据累加起来放到另外一个表中)(急,急,急)
('INSERT into t_sale_h(vc_saleno,vc_depid,vc_posno,dt_begindate,dt_enddate,vc_shroff,vc_claimman,vc_discountman,vc_changeman,vc_giftman,vc_reserve1,vc_reserve1type,nu_amount,nu_realamt,nu_disamt,vc_memcardno, nu_backstatus,vc_istrans) values ("200407308710050197","002040","871005","2004-07-30 09:05:44.030","2004-07-30 09:09:03.030","8710001","null","8710001","8710001","null","null","null",801.800000,771.800000,26.000000,"000173857",0,"0")'','"','''')
"result" from dual;
这个肯定可以