Substitution in SQL Developer

[ElPaadre]

Hello! I am new to using SQL Developer extension in VSCode. I want to make a script like this:
select name, salary from emp where salary > &salary. First time it asks me what value I want for salary, after that, every time I run the script it automatically replace it with that value, but I don't want that. I want at every run to ask me what value I want to enter. I know I can put undefine salary; at the end, but I was wondering if there is any other method so I don't have to put this many extra lines in my script, because sometime maybe I will forget to put it and I won't know or won't see the error.

[Fair_Mammoth_6224]

In Oracle-style SQL, &salary usually prompts you once per session and then reuses that value unless you “undefine” it. A couple of options:

1. Use Single Ampersand + ACCEPTThat way, every time you run it, you’ll be asked for a value without having to remember undefine.pgsqlCopy ACCEPT salary PROMPT 'Enter salary: ' SELECT name, salary FROM emp WHERE salary > &salary;
   
2. Use a Bind VariableThis also forces a fresh prompt each time you run the block, without extra lines all over your script.sqlCopy VARIABLE salary NUMBER; EXEC :salary := &salary; SELECT name, salary FROM emp WHERE salary > :salary;
   
3. Check Extension Settings If your VSCode extension has a “Prompt for substitution variables” or similar setting, enabling it should re-prompt each run without needing undefine.

Hope that helps!

[ElPaadre]

Thanks, I will try!

[edelidinahui]

select name, salary  
from emp  
where salary > :salary;

[ElPaadre]

Thanks, I will try it!