How to avoid variable substitution in Oracle SQL Developer with trinidad tobago

Question

When I try to execute this statement in Oracle SQL Developer 2 1 a dialog box  Enter Substitution Variable  pops up asking for a replacement value for TOBAGO   update t set country    Trinidad and Tobago  where country    trinidad  amp  tobago     How can I avoid this without resorting to chr 38  or u trinidad  0026 tobago  which both obscure the purpose of the statement

User · Accepted Answer

Call this before the query   set define off    Alternatively  hacky   update t set country    Trinidad and Tobago  where country    trinidad  amp        tobago       From Tuning SQL Plus      SET DEFINE OFF disables the parsing of commands to replace   substitution variables with their values

User · Answer

In SQL Plus putting SET DEFINE   at the top of the script will normally solve this  Might work for Oracle SQL Developer as well

User · Answer

this will work as you asked without CHAR 38     update t set country    Trinidad and Tobago  where country    trinidad  amp       tobago    create table table99 col1 varchar 40    insert into table99 values  Trinidad  amp         Tobago    insert into table99 values  Trinidad  amp         Tobago    insert into table99 values  Trinidad  amp         Tobago    insert into table99 values  Trinidad  amp         Tobago    SELECT   FROM table99   update table99 set col1    Trinidad and Tobago  where col1    Trinidad  amp       Tobago

User · Answer

set scan off  Above command also works

[oracle] How to avoid variable substitution in Oracle SQL Developer with 'trinidad & tobago'

Examples related to oracle

Examples related to oracle-sqldeveloper