如何在 TOAD 中转义符号? [英] How to escape ampersand in TOAD?

问题描述

当我尝试插入一个带有&"的值时在 TOAD 中，我得到一个替代变量的提示.

When I try to insert a value which has '&' in TOAD I get a prompt for a substitution variable.

所以当我尝试时:

insert into x values('hello & world'); 

它会提示替换变量world".

it throws a prompt for substituting the variable 'world'.

我尝试在编辑器中右键单击并禁用替换变量提示，但这似乎仅适用于执行语句 (F9) 它不适用于作为脚本执行 (F5).

I have tried right clicking in the editor and disabling prompt for substitution variables but this seems to work only for Execute Statement (F9) It doesn't work for Execute as script(F5).

我也知道使用 chr(38) 就像:

I am also aware of using chr(38) like:

insert into x values('hello '||chr(38)||'world');

但我不想要这个.还有什么可以帮助我运行脚本的吗?

but I do not want this. Is there something else that will help me run the script?

推荐答案

尝试将 set define off 放在脚本的开头.它应该与 F5 一起使用:

Try putting set define off at the beginning of your script. It should work with F5:

set define off;
insert into x values('hello & world'); 
set define on;

这篇关于如何在 TOAD 中转义符号?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！