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

"Officer" <raboasia_at_pacific.net.sg> a écrit dans le message de news:bttod8$vj7$1_at_nobel.pacific.net.sg...
> 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;
>

You can do something like this:

Col retval noprint new_value retval
Select decode(func_get_valid_answer, <what number you want>, 0, 1) from dual; exit &retval

Regards
Michel Cadot Received on Mon Jan 12 2004 - 04:36:29 CST