oracle sql语句传变量
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/09/20 15:18:06
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')换成一个时间类型的变量
急!
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')换成一个时间类型的变量
急!
使用游标,单纯的SQL没法实现.
再问: 能说的详细点吗?
再答: 还是要看你实现什么功能,这个用法不是万能的。 Declare Cursor Cur_XX(V_Date in Date) is select ... from Table_Name where trunc(WEIGHTTIME)=V_Date; Begin For cx in Cur_XX(trunc(Sysdate)) Loop ..... End Loop; End;
再问: 能说的详细点吗?
再答: 还是要看你实现什么功能,这个用法不是万能的。 Declare Cursor Cur_XX(V_Date in Date) is select ... from Table_Name where trunc(WEIGHTTIME)=V_Date; Begin For cx in Cur_XX(trunc(Sysdate)) Loop ..... End Loop; End;
oracle sql语句获取前两条数据
oracle sql 语句中where条件中 1=1
ORACLE中between…and...是SQL语句中的吗?还是仅限于SQL*PLUS里?
请问oracle的commit等于锁表么?如果不一样,那如何锁表呢?另外,好像在sql server中insert语句后
麻烦大家用oracle给我建张表,sql语句: id int 主键,自增长 name Varchar(50) 学生姓名
sql,oracle中语句执行顺序?sql中between 20 and 0 是否和0 and 20所查出的数据一样?
oracle 语句优化问题
oracle 语句 查询优化
SQL语句的where
SQL语句case when
ORACLE SQL 获取26个大写英文字母A-Z
SQL 查询语句的问题