Re: Interaction in sql*plus

I hope this is what you're lookinG for...

select * from sales where closed ='&YES_OR_NO:'; this will automatically prompt you to enter a value..

You could also use

accept par1 prompt "Please enter value(Y or N'):" set verify off
select * from sales where closed='&par1';

Cheers, Robert Prendin
Casper Thrane <ct_at_benau.dk> wrote:

>Hi!
>
>I have seen in other that, there is yes/no questions. If you answer yes
>then one thing happens and if you answer no another thing happens.
>How can I accomplish this, in my sql scripts?
>--
>Casper Thrane
>System developer
>Benau A/S
Received on Wed Dec 03 1997 - 00:00:00 CST