Re: Differences between DECODE and 9i's CASE

From: Donovan R. <mdonovan_at_hotmail.com>
Date: Tue, 11 Feb 2003 20:25:15 -0500
Message-ID: <0e8j4vgsq152iul5sjbp8s8omlrm9bfb1m_at_4ax.com>

I guess CASE is some SQL ANSI standard, is there in order to be potable to MSSQL or Sybase by example. With 9i the syntax for the joins OUTER/INNER LEFT/RIGHT/FULL are introduced also.

On Tue, 11 Feb 2003 15:58:34 -0600, "Peter Shankey" <oxmard.Rules_at_ab.ab> wrote:

>The CASE expressions and the function DECODE seem to do the same thing. What
>are the advantages of one over the other?
>
Received on Wed Feb 12 2003 - 02:25:15 CET

This message: [ Message body ]
Next message: Ethel Aardvark: "Re: how to return a record from pl/sql function"
Previous message: web guy: "how to return a record from pl/sql function"
Next in thread: Tim Cuthbertson: "Re: Differences between DECODE and 9i's CASE"
Maybe reply: Tim Cuthbertson: "Re: Differences between DECODE and 9i's CASE"

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

Original text of this message