How to clear stored substitution variables in Oracle SQL developer

Question

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?

smshafiqulislam · Accepted Answer · 2017-05-30 16:36:32Z

7

UNDEFINE starttime;

Just use above command.

answered May 30, 2017 at 16:36

smshafiqulislam

5946 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gary_W · Accepted Answer · 2017-05-30 18:37:17Z

4

Just use one ampersand at the start. You will be prompted to enter the value fresh. See the difference between & and &&

edited May 30, 2017 at 18:37

answered May 30, 2017 at 18:31

Gary_W

10.4k1 gold badge26 silver badges42 bronze badges

Comments

ℛɑƒæĿᴿᴹᴿ · Accepted Answer · 2021-05-09 13:32:47Z

2

You can try these commands:

select &&v_value from table_name;
undefine v_value;

edited May 9, 2021 at 13:32

ℛɑƒæĿᴿᴹᴿ

5,4765 gold badges43 silver badges61 bronze badges

answered May 8, 2021 at 18:12

Marcel

4844 silver badges9 bronze badges

Collectives™ on Stack Overflow

How to clear stored substitution variables in Oracle SQL developer

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related