How to clear stored substitution variables in Oracle SQL developer

user_6374050 0
Viewed 13767

Suppose I have a query:

SELECT * from table1 tr where tr.start_time < &&starttime;

First time i execute the query, SQL Developer prompts me to enter the value for the substitution variable 'starttime' and is stored. Next time I run the script, it reuses the same value again, how do I reset/clear the stored value?

oracle-sqldeveloper oracle sql
3 Answers

You can try these commands:

select &&v_value from table_name;
undefine v_value;
user_29153830
Related