就是如何把中间insert语句里的双引号改成单引号。我最后执行insert 的时候不可能带着双引号执行啊

解决方案 »

  1.   

    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;
    这个肯定可以