Oracle数据库SQL语句中有"&"执行失败

这是在一次更新表数据中遇到的情况

错误的语句：

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