摘要：
select * from (select a.* row_number() over(partition by a.task_type,to_char(a.oper_time,'yyyymmdd') order by a.oper_time desc) rank from test a ) t w 阅读全文
摘要：
with t1 as(select d.p-d.dlrt cha,d.* from (select c.*, rank() over(partition by c.cos_id order by c.dlrq desc) as rank2 from (select b.cos_id, b.dlrq, 阅读全文
摘要：
select date '2020-11-17' from dual; -- 2020/11/17 阅读全文
摘要：
SELECT SYSDATE ,TRUNC(SYSDATE),TRUNC(SYSDATE -1),SYSDATE-1/24 FROM DUAL;2020/11/17 10:58:06 2020/11/17 2020/11/16 2020/11/17 9:58:06 阅读全文
摘要：
1.instr('源字符串','目标字符串’，'开始位置','第几次出现')函数select instr('BRD_SOI_standard-202011120.xml','-') from dual;--172、TO_DATA(substr('BRD_SOI_standard-202011120. 阅读全文