Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: checking the input of ACCEPT
You can use substitution variables and pass the variable to be checked
to the stored procedure which will do(or not do) the drop the
user(dynamic sql) based on the variable passed. Look up the
substitution variable ampersand (&) in the SQL*Plus manual
"J?g Schneider" <Joerg.Schneider_at_ORGAPLAN_NOSP.de> wrote in message news:<ag4991$i3e$1_at_newsreader2.netcologne.de>...
> Hello together,
>
> we want to drop users in a database by a script with sqlplus. There should
> be warnings and an input like "The user will be deleted. Are you shure?
> (Y/N)" before the drop. Now we have to check the input wether there is "Y"
> or "N"? How can we do this?
>
> Source:
>
> ACCEPT x char PROMPT "The user will be deleted. Are you shure? (Y/N)"
>
> Thank you for helping
>
> Jörg
Received on Fri Jul 05 2002 - 13:28:29 CDT