用来条件判断的情况
select
decode(PARTSNAME_NAME, null, '111','螺纹钢','222', '钢坯','333',PARTSNAME_NAME) 合同号,
PARTSNAME_NAME 品名,
GOODS_MATERIAL,
GOODS_SPEC 规格,
PARTSNAME_NAME || GOODS_SPEC 牌名,
PRODUCTAREA_NAME 产地,
GOODS_NUM 实提数量,
GOODS_WEIGHT 实提重量
from warehouse_delivery_detail;
select PARTSNAME_NAME 品名,GOODS_MATERIAL,GOODS_SPEC 规格,PARTSNAME_NAME||GOODS_SPEC 牌名,PRODUCTAREA_NAME 产地,GOODS_NUM 实提数量,
GOODS_WEIGHT 实提重量,decode(GOODS_CONTRACTSTR1, null, GOODS_CONTRACT, GOODS_CONTRACTSTR1 ) 合同号
from warehouse_delivery_detail
可以参考网址:https://blog.csdn.net/w11abandon/article/details/126888807