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 -> help with decode

help with decode

From: <soup_or_power_at_yahoo.com>
Date: 3 Aug 2005 06:53:56 -0700
Message-ID: <1123077235.993160.88610@g47g2000cwa.googlegroups.com>


Can anyone tell me how the ||'s are interpreted in the DECODE below? I was thinking string concatenation, but shouldn't there be commas after 'M' and 'T'?
Many thanks for your help.

SELECT
        DECODE(NVL(template_id,0),0,'M' || mailing_id,'T' || template_id),

        from A Received on Wed Aug 03 2005 - 08:53:56 CDT

Original text of this message

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