How to undo && variable substitution
Hello
I have the following question:
I have a query with many unions:
select a from table where column='&¶m'
union
select a from table2 where column='&¶m'
.........................................................................
select a from table10 where column='&¶m'
I'm using && otherwise SQL Developer will ask me 10 times to enter value for &¶m.
Now I want to run for a different parameter. How do I make SQL Developer to prompt me again for variable value?