Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Re: Use DECODE result in WHERE clause?

Re: Use DECODE result in WHERE clause?

From: Tonkuma <tonkuma_at_fiberbit.net>
Date: Thu, 20 Sep 2007 14:12:38 -0700
Message-ID: <1190322758.957945.229860@i13g2000prf.googlegroups.com>

I think that
DECODE(r.cd_status, NULL, p.cd_status, r.cd_status) can be replaced with
NVL(r.cd_status, p.cd_status). Received on Thu Sep 20 2007 - 16:12:38 CDT

This message: [ Message body ]
Next message: sybrandb_at_hccnet.nl: "Re: Application migration from non RAC databases to RAC databases"
Previous message: hpuxrac: "Re: Best fs for Oracle RAC"
In reply to: fitzjarrell_at_cox.net: "Re: Use DECODE result in WHERE clause?"

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