Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is IF ELSE statement can be used inside sqlplus?
"Officer" <raboasia_at_pacific.net.sg> a écrit dans le message de
news:bttfd7$73t$1_at_nobel2.pacific.net.sg...
> Is it possible to use IF ELSE statement inside sqlplus?
>
> I try to use it couple times, it seems sqlplus does not like it. Any
> example?
>
>
May be this what you're searching for:
select case ... when ... when ... else ... end from ...;
Regards
Michel Cadot
Received on Mon Jan 12 2004 - 02:45:06 CST