Re: Newbie Question about USER Input

From: Softteam <bla_at_fasel.de>
Date: Sat, 19 Oct 2002 22:01:14 +0200
Message-ID: <aosdku$ctu$07$1@news.t-online.com>

even better this way .... ;-)

DECLARE
    user_y char(1);
BEGIN

      select upper('&user_x')
      into user_y
      from dual;

    if user_y = 'A' then
      dbms_output.put_line('A');
    elsif user_y = 'B' then
      dbms_output.put_line('B');
    else
      dbms_output.put_line('Bad selection');

    end if;
end;

Kind regards
J.F.Sebastian Received on Sat Oct 19 2002 - 15:01:14 CDT