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

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Mon, 12 Jan 2004 09:36:17 +0100
Message-ID: <bttmfh$b4i37$1@ID-152732.news.uni-berlin.de>

"Officer" <raboasia_at_pacific.net.sg> schrieb im Newsbeitrag 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?
>
>

IF THEN ELSE END IF is PL/SQL, not SQL,
so If You want to use it, write at least an anonymous PL/SQL-Block

For further details goto http://tahiti.oracle.com Received on Mon Jan 12 2004 - 02:36:17 CST

This message: [ Message body ]
Next message: Michel Cadot: "Re: Is IF ELSE statement can be used inside sqlplus?"
Previous message: Rene Nyffenegger: "Re: Is IF ELSE statement can be used inside sqlplus?"
In reply to: Officer: "Is IF ELSE statement can be used inside sqlplus?"
Next in thread: Officer: "Re: Is IF ELSE statement can be used inside sqlplus?"
Reply: Officer: "Re: Is IF ELSE statement can be used inside sqlplus?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US