Re: Interaction in sql*plus

You could also do something like:

spool next_step.sql

accept ans prompt "Please enter S for sales or C for cost: "

select decode('&ans','S','_at_sales','C','_at_cost','_at_error') from dual;

spool off

_at_next_step

This uses the spool file as a temporary area to store the conditional next step.

Robert Prendin wrote:
>
> 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 CET