Oracle的NVL函数

NVL函数

从两个表达式返回一个非null值

语法格式
NVL(eExpression1, eExpression2)

语法说明
eExpression1和eExpression2可以是任意一种数据类型

如果，eExpression1的计算结果不是null值，则返回eExpression1
如果，eExpression1的计算结果为null值，则NVL()返回eExpression2
如果，eExpression1与eExpression2的结果皆为null值，则NVL()返回NULL

示例代码

SELECT
    NVL (
        (
            DECODE (
                '2',
                (
                    SELECT
                        BIZ_ITEM_TYPE
                    FROM
                        DIC_ASSAY_BUSINESS_ITEM
                    WHERE
                        ID = ASSAY_BIZ_ITEM_ID
                ),
                (
                    SELECT
                        ASSAY_ITEM_NAME
                    FROM
                        DIC_ASSAY_ITEM
                    WHERE
                        ID = (
                            SELECT
                                BIZ_ITEM_ID
                            FROM
                                DIC_ASSAY_BUSINESS_ITEM
                            WHERE
                                ID = ASSAY_BIZ_ITEM_ID
                        )
                ),
                (
                    SELECT
                        BIZ_TASK_NAME
                    FROM
                        DIC_BUSINESS_TASK
                    WHERE
                        ID = (
                            SELECT
                                BIZ_ITEM_ID
                            FROM
                                DIC_ASSAY_BUSINESS_ITEM
                            WHERE
                                ID = ASSAY_BIZ_ITEM_ID
                        )
                )
            )
        ),
        (
            SELECT
                NAME
            FROM
                DIC_ASSAY_ITEM_CATE
            WHERE
                ID = ASSAY_BIZ_ITEM_CATE_ID
        )
    ) AS catename,
    < INCLUDE refid = "Base_Column_List" />
FROM
    DIC_ASSAY_BIZ_ITEM_CHARGE
WHERE
    1 = 1