Oracle SQL escape character for a

Question

While attempting to execute SQL insert statements using Oracle SQL Developer I keep generating an  Enter substitution value  prompt   insert into agregadores agregadores     idagregador   nombre   url    values     2    Netvibes     http   www netvibes com subscribe php type rss  amp amp url        I ve tried escaping the special character in the query using the     above but I still can t avoid the ampersand    amp    causing a string substitution

User · Accepted Answer

the  amp  is the default value for DEFINE  which allows you to use substitution variables   I like to turn it off using  SET DEFINE OFF  then you won t have to worry about escaping or CHR 38

User · Answer

chr 38      This solution is perfect

User · Answer

add this before your request  set define off

User · Answer

select  one     amp     two  from dual

User · Answer

Set the define character to something other than  amp    SET DEFINE   create table blah  x varchar 20    insert into blah  x  values   blah amp amp    select   from blah   X                     --------------------  blah amp amp

User · Answer

The real answer is you need to set the escape character to      SET ESCAPE ON  The problem may have occurred either because escaping was disabled  or the escape character was set to something other than       The above statement will enable escaping and set it to         None of the other answers previously posted actually answer the original question   They all work around the problem but don t resolve it

User · Answer

SELECT  Free  amp        Clear  FROM DUAL

User · Answer

insert into AGREGADORES AGREGADORES  IDAGREGADOR NOMBRE URL  values  2  Netvibes    http   www netvibes com subscribe php type rss     chr 38      amp url

[sql] Oracle SQL escape character (for a '&')

Examples related to sql

Examples related to oracle

Examples related to escaping

Examples related to oracle-sqldeveloper