执行语句
Select 'Tom & Jerry' from dual;
你会很受伤,弹出将Jerry作为输入变量的提示框
正确做法
Select 'Tom' || chr(38) || 'Jerry' from dual;
Select 'Tom' || '&' || 'Jerry' from dual;
执行语句
Select 'Tom & Jerry' from dual;
你会很受伤,弹出将Jerry作为输入变量的提示框
正确做法
Select 'Tom' || chr(38) || 'Jerry' from dual;
Select 'Tom' || '&' || 'Jerry' from dual;