Re: Basic DECODE Question.....

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 20 Feb 2003 09:40:14 +0000
Message-ID: <b320r0$9n5$1@ctb-nnrp2.saix.net>

Andrew Allen wrote:

> About 255 pairs. Though if you are using 9i consider using the CASE
> statement as the DECODE statement is being deprecated.

CASE also works with Oracle 8.1.7 (and likely thus with all 8 versions).

Does not exist in Oracle 7.

--
Billy

Received on Thu Feb 20 2003 - 03:40:14 CST

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

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