随笔-26  评论-13  文章-46  trackbacks-0

In Oracle/PLSQL, the coalesce function returns the first non-null expression in the list. If all expressions evaluate to null, then the coalesce function will return null.

The syntax for the coalesce function is:

coalesce( expr1, expr2, ... expr_n )


For Example:

You could use the coalesce function in an SQL statement as follows:

SELECT coalesce( address1, address2, address3 ) result
FROM suppliers;


The above coalesce statement is equivalent to the following IF-THEN-ELSE statement:

IF address1 is not null THEN
     result := address1;

ELSIF address2 is not null THEN
    result := address2;

ELSIF address3 is not null THEN
    result := address3;

ELSE
    result := null;

END IF;


The coalesce function will compare each value, one by one.

posted on 2006-04-04 10:15 似水流年 阅读(411) 评论(0)  编辑  收藏 所属分类: Oracle

只有注册用户登录后才能发表评论。


网站导航: