这是在一次更新表数据中遇到的情况
错误的语句:
update invoice c
set c.invoicenumber = '05803927',
c.pdfurl = 'http://127.0.0.1:8080/einvoice/invoices/file?invoiceNumber=05803927&invoiceCode=042001600311'
where c.no = '600000031101201710032151497';
正确的语句:
update invoice c
set c.invoicenumber = '05803927',
c.ctrippdfurl = 'http://127.0.0.1:8080/einvoice/invoices/file?invoiceNumber=05803927'||chr(38)||'invoiceCode=042001600311'
where c.policyno = '600000031101201710032151497';
chr(38)是‘&’的ASCII码
可以调用ascii函数查到对应的号码,如:select ascii('&') from dual; 结果:38