30/04/2009 : Oracle SQL Developer SQL Worksheet And Ampersands
If you attempt to run SQL queries in a SQL worksheet and that query includes ampersands then SQL Developer will prompt you for bind variable values. It assumes anything starting with an ampersand must be a bind variable.
For example the query below :
SELECT * FROM TBL_COLOURS WHERE colour = 'Red&Blue';
would result in a pop-up window asking for a value for "&Blue".
If you are running a few thousand update queries containing lots of text it is very annoying.
There are 2 ways of avoiding it. Either replace all occurances of & with ' || '&' || '
SELECT * FROM TBL_COLOURS WHERE colour = 'Red' || '&' || 'Blue';
Or use the SQL Plus command :
SET DEFINE OFF;
Links:
Author : Matt Hawkins Last Edited By : Matt Hawkins Permalink : Oracle SQL Developer SQL Worksheet And Ampersands
MattHawkins CMS v2.0 - Copyright 2009-2010