CASE statement implemented?

From: Stefan Sandow <stefan.sandow_at_gmx.de>
Date: Mon, 22 Feb 1999 17:15:43 +0100
Message-ID: <7arvls$3q5$1@black.news.nacamar.net>

Hi there,
I desparate need to know if there is a CASE statement implemented in Oracle 8, where you can evaluate expressions like the following:

CASE
WHEN

        (a>b)
            then 'greater'
       else
           'not greater'

end
I know that there is a DECODE, BUT..
It can't do things like:
DECODE((a>b), True, 'greater', 'not greater')

Thanks for any usefull suggestion!
Stefan Received on Mon Feb 22 1999 - 10:15:43 CST