In SQLDev 18.3 I'm exploring substitution variables and I know that &VarName ask everytime for a value when I run SQL and &&VarName ask only for the first time. My Q is how can I trigger/cause that I will be prompted again for a new value If I would like to change value, like I would execute this SQL for the first time?
I found out that I can use Define command and set another value, but I would just like to reset this value without another line of code and be prompted like for the first time. The other option I found is to copy the same SQL in new worksheet and run code from there. Can I achieve this on some easier or faster way without Define command or copy SQL sentence to a new worksheet?
Thanks,
BB