Ask for a variable only once.

[nuct]

Hi, How do I make it so that my query askes for value of a variable only once. E.g.

Select name, no
From students
Where no in ('&number','&number' -1)

... or something along those lines

At the moment it asks for &number twice, i want it so i only get asked once each time it is run.

Thanks,

Simon H.

 

[OraCool]

Try This

Select name, no
From students
Where no in ('&&number','&&number' -1)

Notice there are two '&' prefixing the variable

 

[nuct]

Yeah this is good, but the only problem is that when i run the query for a second time it doesn't give me any prompts at all, any ideas.

Thanks,

Simon.

 

[OraCool]

Ok, put this line at the end of the script:

Select name, no
From students
Where no in ('&&number','&&number' -1)
/
undefine number

 

[nuct]

You the man, thanks.

I'll try this tomorrow.

Simon.