Re: Is IF ELSE statement can be used inside sqlplus?

• Original Message ----- From: "Officer" <raboasia_at_pacific.net.sg> Newsgroups: comp.databases.oracle.misc Sent: Monday, January 12, 2004 11:12 AM Subject: Re: Is IF ELSE statement can be used inside sqlplus?

> What i want to accomplish is i want to evaluate returned value from the
> function.
>
> I know if then else is an pl/sql not sql so i post the question here.just
in
> case anybody has ever done it before.
>
> declare
> myout number;
> Begin
> myout:=func_get_valid_answer;
> if myout equal to true(certain number) then
> exit from this sqlplus session with exit code 0
> if myout equal to false then
> exit from this sqlplus session with exit code 1
> End;
>

where's your "END IF"? Looks like its a syntax error...

IF condition1 THEN

   sequence_of_statements1
ELSIF condition2 THEN

   sequence_of_statements2
ELSE
   sequence_of_statements3
END IF;

• \|/ Onismus o o __________________________________oOO_(_)_OOo______________________________ E-Business and Information Management | Tel: +27 11 350 3414 Knowledge Discovery & Dissemination | Fax: +27 11 350 8585 onismusr-AT-absa-DOT-co-DOT-za | Cel: +27 83 591 5310

  ---