在PLSQL执行下面的sql:
Insert into LDMENU (NODECODE,PARENTNODECODE,NODELEVEL,NODENAME,CHILDFLAG,NODEKEY,RUNSCRIPT,NODESIGN,NODEDESCRIPTION,NODEORDER) values ('3115','3111',null,'报文生成','0',null,'../aml/MCIHFileToXml.jsp?reportType=01&dataType=05',null,null,92);
报错如下:
问题:字段中存在&
解决方案:将&替换为'||'&'||'