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