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\&url='
);
I've tried escaping the special character in the query using the '\' above but I still can't avoid the ampersand, '&', causing a string substitution.
the & 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).
Set the define character to something other than &
SET DEFINE ~
create table blah (x varchar(20));
insert into blah (x) values ('blah&');
select * from blah;
X
--------------------
blah&
insert into AGREGADORES_AGREGADORES (IDAGREGADOR,NOMBRE,URL)
values (2,'Netvibes',
'http://www.netvibes.com/subscribe.php?type=rss' || chr(38) || 'amp;url=');