Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: jbatista@abcsolutions.org (Josue Batista)
Newsgroups: comp.databases.oracle.misc
Subject: DECODE question
Date: 11 Nov 2002 18:02:31 -0800
Organization: http://groups.google.com/
Lines: 12
Message-ID: <f9a7c16c.0211111802.66cc397c@posting.google.com>
NNTP-Posting-Host: 151.201.22.49
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1037066552 12788 127.0.0.1 (12 Nov 2002 02:02:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Nov 2002 02:02:32 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:89236
X-Received-Date: Mon, 11 Nov 2002 19:02:17 MST (news.easynews.com)

Given the following two columns:

ACCTD_AMOUNT_DUE_REMAINING      NOT NULL NUMBER
AMOUNT_DUE_REMAINING            NOT NULL NUMBER

What does the following statement mean?

sum(decode(NULL,'Y',acctd_amount_due_remaining,amount_due_remaining))

What is the interpretation of the "DECODE(NULL,'Y',..."?

Thanks in advance.