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: coalesce - in sql query?

Re: coalesce - in sql query?

From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 29 Nov 2002 17:10:49 GMT
Message-ID: <3DE79F95.10FD8073@exesolutions.com>


"Randi Wølner" wrote:

> I have been asked why one particular query will not run in our Oracle
> database. The query contains the word coalesce, used as if it was a
> function.
>
> I know how coalesce is used for defragmentation in Oracle, but have never
> seen it used in a query before, and can not find any references to this use
> in the documentation. By searching in newsgroup archives I have found
> references for SAS and MS SQL Server to this function, so my question is:
> Is Coalesce a non-standard part of SQL used by some vendors, while others
> (Oracle) choose not to implement it..? It seems like the use of it can be
> replaced by a combination of NVL and DECODE.
>
> Thanks,
> Randi Wølner

SELECT keyword
FROM v$reserved_words
WHERE keyword LIKE 'COA%';

and you will find your answer.

Daniel Morgan Received on Fri Nov 29 2002 - 11:10:49 CST

Original text of this message

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