oracle SQL语句

Oracle SQL语句

oracle 表名@xx
这个是链路查询

是查另一个oracle的数据

xx这个表在另一个数据库里面也有

从2019-1-1 到2019-1-31
to_char(DATA_TIME, ‘yyyy-mm-dd’) between to_char(trunc(to_date(?, ‘yyyy-mm’), ‘yyyy’), ‘yyyy-mm-dd’) and to_char(last_day(to_date(?, ‘yyyy-mm’)), ‘yyyy-mm-dd’)

时间格式
select to_char(to_date(‘2019-11-1’,‘yyyy-mm-dd’),‘yyyy"年"mm"月"dd"日"’) as data_dt from dual;

1-12月
select
mm_zh_consume,
mm_sw_value,
mm_total_outputp,
mm_total_outputc,
mm_add_outputp,
mm_add_outputc,
mm_sc_value,
mm_power_value,
mm_inst_value
from
dual
left join (
select
*
from
rpt_month_gfwt
where
siteid = ?
and DATA_TIME = TO_DATE(
substr(concat(?, ‘9999’), 0, 4) || ‘-01’,
‘yyyy-mm’
)
) t on 1 = 1;

时间从当月第一天到当月最后一天

select sum(DD_POWER_VALUE),
sum(UN_PLAN_STOP_NUM),
sum(UN_PLAN_STOP_HOURS),
sum(UN_PLAN_RUN_HOURS),
max(DD_POWER_VALUE),
max(UN_PLAN_STOP_NUM),
max(UN_PLAN_STOP_HOURS),
max(UN_PLAN_RUN_HOURS)
from rpt_day_fdwt
where siteid = ‘40400’ and
to_char(DATA_TIME, ‘yyyy-mm-dd’) between
to_char(trunc(to_date(‘2021-02’, ‘yyyy-mm’), ‘mm’), ‘yyyy-mm-dd’) and
to_char(last_day(to_date(‘2021-02’, ‘yyyy-mm’)), ‘yyyy-mm-dd’)