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/10/03 02:10:54
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没法实现.