SqlDbx Forum

isql

Member

clear sql prompt cache/buffer

I made an Oracle script with a prompt and it works fine. But when I will run it again, I would expect that I must enter the value for the prompt again. The script will run with the first entered value. How can I clear the cache for the prompt so that I can enter an new value for the prompt?

sqldbxhelp

Administrator

Re: clear sql prompt cache/buffer

Here's how you can do it

define last_name char
select * from table where lastname = &last_name;

Select both lines and execute. You will be asked for last_name every time you run it.
If you want to have default value for last_name then you can define last_name as:
define last_name = 'Smith' char