oracle sql语句传变量nvl((select sum(NETWEIGHT) from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab where jl.DATANUM = ab.datanum and jl.siteid = ab.siteid and jl.orgid = ab.orgid
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/25 17:28:37
![oracle sql语句传变量nvl((select sum(NETWEIGHT) from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab where jl.DATANUM = ab.datanum and jl.siteid = ab.siteid and jl.orgid = ab.orgid](/uploads/image/z/14663086-70-6.jpg?t=oracle+sql%E8%AF%AD%E5%8F%A5%E4%BC%A0%E5%8F%98%E9%87%8Fnvl%28%28select+sum%28NETWEIGHT%29+++++++++++++++++from+ST_WEIGHTETL+jl%2C+ST_FUELCOMMDATA+ab++++++++++++++++where+jl.DATANUM+%3D+ab.datanum++++++++++++++++++and+jl.siteid+%3D+ab.siteid++++++++++++++++++and+jl.orgid+%3D+ab.orgid)
oracle sql语句传变量nvl((select sum(NETWEIGHT) from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab where jl.DATANUM = ab.datanum and jl.siteid = ab.siteid and jl.orgid = ab.orgid
oracle sql语句传变量
nvl((select sum(NETWEIGHT)
from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab
where jl.DATANUM = ab.datanum
and jl.siteid = ab.siteid
and jl.orgid = ab.orgid
and ab.WEIGHTR_STATUS = '已确认'
and to_char(ab.WEIGHTTIME, 'yyyy-mm-dd') =
to_char(sysdate,'yyyy-mm-dd')
and ab.COMPANYNUM = ss.COMPANYNUM
and ab.YEARPLANTYPE = ss.YEARPLANTYPE),
0) as 日进煤量
nvl((select sum(NETWEIGHT)
from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab
where jl.DATANUM = ab.datanum
and jl.siteid = ab.siteid
and jl.orgid = ab.orgid
and ab.WEIGHTR_STATUS = '已确认'
and to_char(ab.WEIGHTTIME, 'yyyy-mm') =
to_char(sysdate,'yyyy-mm')
and ab.COMPANYNUM = ss.COMPANYNUM
and ab.YEARPLANTYPE = ss.YEARPLANTYPE),
0) as 月进煤累计
如何把查询中设计到的系统时间的判断to_char(sysdate,'yyyy-mm-dd')换成一个时间类型的变量
急!
oracle sql语句传变量nvl((select sum(NETWEIGHT) from ST_WEIGHTETL jl, ST_FUELCOMMDATA ab where jl.DATANUM = ab.datanum and jl.siteid = ab.siteid and jl.orgid = ab.orgid
使用游标,单纯的SQL没法实现.