Re: CASE strucrure in PL/SQL

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 04 Jun 2003 20:57:11 +0200
Message-ID: <n2gsdv81e7162v0h3fkn5qekb0vq6qmgs1@4ax.com>

On Wed, 4 Jun 2003 09:45:59 +0200, "Onismus Radebe" <onismusr_at_absa.co.za> wrote:

...
>Bob I got the syntax from a Student Guide for Oracle 9i and the server that
>I'm using is 8i I think that might be the reason causing all of this. I
>could have used the IF structure because I'm lazy to type I decided to use
>CASE. We 'll be moving to Oracle 9i in a month until then I 'll have to use
>the IF --- THEN ---ELSIF---ELSE---END IF structure.
...

From the Oracle 9i SQL Reference Manual:

"CASE expressions let you use IF ... THEN ... ELSE logic in SQL statements"

So *not* in an assignment statements as in your example.

Jaap. Received on Wed Jun 04 2003 - 13:57:11 CDT