Escape ampersand in PL/SQL Developer
At the bottom of a SQL window there is a button to disable/enable substitution variables:
One of the features of PL/SQL Developer which it takes time to get familiar with is the plethora of different window types.
One of these is the COMMAND window, which is basically a SQL*Plus emulator. We can run SQL*Plus commands as well as SQL, so SET ESCAPE
, SET DEFINE
and indeed SET SCAN OFF
work in that window.
How I solved it is escaping the & with another &.
For example:
INSERT INTO Foo (Bar) VALUES ('Up && Away');
Works nicely. Thanks for all the help