SQL Developer

I am using the '&' in a very basic SQL select script, but I do not get a prompt for my input. However, i have used the '&' in update scripts and it does prompt me.

For example:

select DCC_DESCRIPTION
from S_TBLDTMINOR
where DCC_DTMINOR = &Minor;

Gives an ORA-01008 error (not all variables bound).

If it's a varchar field and I use '&Minor' - it executes with no error, but does not prompt for data. Please note: this script works when it's run in SQL*Plus, but not in SQL Developer.

If I execute:

update S_TBLDTMINOR
set DCC_DESCRIPTION = 'Mark & Wilson'
where DCC_DTMINOR = 'AAA';

It does prompt me for a value (but I do not want it to).

So I know prompting works in SQL Developer, but it does not work in select statements.

Is this a configuration setting I can change in SQL Developer? I know I can use the escape in the update statement to avoid the prompt, but I'm not concerned with that. I'm trying to get the prompting to work in the select statement.

Edited by: user12289057 on Feb 23, 2012 11:17 AM