Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: coalesce - in sql query?
"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