Re: checking the input of ACCEPT

From: Rauf Sarwar <rsarwar_at_ifsna.com>
Date: 5 Jul 2002 11:29:31 -0700
Message-ID: <c2d690f2.0207051029.2c8b034e@posting.google.com>

"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

ACCEPT drop_user DEFAULT 'N' PROMPT 'The user will be deleted. Are you sure? (Y/N) '

BEGIN
IF Upper(Substr('&drop_user', 1, 1)) = 'Y' THEN

EXECUTE IMMEDIATE '.......';
END IF;
END;
/

HTH
//Rauf Sarwar Received on Fri Jul 05 2002 - 13:29:31 CDT