Search code examples
oracle-sqldeveloper

SQLDeveloper doesn't prompt for input a second time

I'm used to Toad, where just by clicking F9 it would automatically prompt me to type my input parameters for any query.

However, in SQLDeveloper I am only prompted to input them once, & then every time I use F9 the tool uses the inital parameters, forcing me to close & reopen a script if I want to change the parameter.

Do you know of any command to prevent this?

Solution

  • I wasn't able to resolve it permanently, but I found a work-around. Probably it's even the correct approach.

    In order to reuse a variable in a query, particularly in SQL Developer, use "UNDEFINE":

    UNDEFINE [variable_name];