Oracle-空值null和数字相加的问题-nvl函数

最新推荐文章于 2021-04-16 05:48:35 发布

原创最新推荐文章于 2021-04-16 05:48:35 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

Orale MySQL 专栏收录该内容

73 篇文章

订阅专栏

本文介绍了一个具体的SQL查询案例，展示了如何从多个表中联接并选择特定字段，同时提供了处理NULL值的有效方法——使用nvl函数。


select t.RECORD_ID as recordId,
       t.HOST_ID as hostId,
       t.HOST_NO as carHostNO,
       t.SECURE_PAY as securePay,
       p.VEHICLE_MODEL as vehicleModel,
       po.APPSYSID as appSysId,
       po.APPDEPTID as appDeptId,
       t.SECURE_NO as secureNo,
       to_char(t.SECURE_START_TIME, 'yyyy-MM-dd HH24:mi:ss') as secureStartTime,
       to_char(t.SECURE_END_TIME, 'yyyy-MM-dd HH24:mi:ss') as secureEndTime,
       t.SECURE_HANDLE as secureHandle,
       t.secure_acc_no as secureAccNo,
       t.secure_acc_pay as secureAccPay,
       t.secure_tax as secureTax,
       t.secure_remark as secureRemark,
       (t.SECURE_PAY + t.secure_acc_pay + t.secure_tax) as SECURE_NUM
  from CAR_SECURE_NEW t, POSITION_HOST_INFO_EXTEND p, POSITION_HOST_INFO po
 where t.host_id = p.hostid
   and t.host_id = po.hostid