Escape ampersand in PL/SQL Developer?

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.

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 E.g. INSERT INTO Foo (Bar) VALUES ('Up && Away'); Works nicely.

Thanks for all the help.

INSERT INTO tablex VALUES ('Sid ' || '&' || ' Nancy'); Improving my first answer, your problem is related with PL/SQL Developer. If you execute your block in a PL/SQL Developer Command window, you could also use the standard SET DEFINE OFF, which works the same as in SQL*Plus.

I don't think that is any more graceful than the chr(38) solution Ray mentions. – APC Aug 18 at 8:52 propably, but it's the one that I used when I faced a similar problem a year ago. In orafaq.Com/wiki/SQL_FAQ there are some nice solutions too in SQL*Plus, like SET ESCAPE '\', SET DEFINE ~ or SET SCAN OFF – Aitor Aug 18 at 8:56.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.