在sql里面插入符号‘
要用 chr(39) 连接
EG:
[size=large][color=red]Select 'Aviva' || Chr(39) || 'S Mycare Direct Customers' From Dual;[/color]
[/size]
Output:
[size=large][color=red]Aviva'S Mycare Direct Customers[/color][/size]
要用 chr(39) 连接
EG:
[size=large][color=red]Select 'Aviva' || Chr(39) || 'S Mycare Direct Customers' From Dual;[/color]
[/size]
Output:
[size=large][color=red]Aviva'S Mycare Direct Customers[/color][/size]