11 2020 档案

python 环境

摘要：48 10 *** source ~/.bash_profile && python /home/dcol/remote/markit/main.py 阅读全文

posted @ 2020-11-20 10:36 rjm123456 阅读(69) 评论(0) 推荐(0) 编辑

摘要：select * from nls_database_parameters a where a.parameter like '%NLS_CHARACTERST%'; 阅读全文

posted @ 2020-11-20 10:31 rjm123456 阅读(610) 评论(0) 推荐(0) 编辑

trigger

摘要：create or replace trigger dcs_batch_id_tri before insert into on dcs_collect_batch for each row when (new.dcs_id is null) begin select dcs_collect_bat 阅读全文

posted @ 2020-11-17 14:21 rjm123456 阅读(75) 评论(0) 推荐(0) 编辑

闪回操作 flashback

摘要：falshback table dcs_collect_bash to timestamp to_timestamp('2020-11-06 18:00:00', 'yyyy-mm-dd hh24:mi:ss') alter table dcs_collect_batch enable row mo 阅读全文

posted @ 2020-11-17 14:16 rjm123456 阅读(82) 评论(0) 推荐(0) 编辑

row_number()over(partiton by order by ) rank() over(partition by order by )

摘要：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 阅读全文

posted @ 2020-11-17 14:11 rjm123456 阅读(211) 评论(0) 推荐(0) 编辑

lag() 偏移

摘要：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, 阅读全文

posted @ 2020-11-17 11:59 rjm123456 阅读(98) 评论(0) 推荐(0) 编辑

date

摘要：select date '2020-11-17' from dual; -- 2020/11/17 阅读全文

posted @ 2020-11-17 11:27 rjm123456 阅读(44) 评论(0) 推荐(0) 编辑

SYSDATE ,TRUNC

摘要：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 阅读全文

posted @ 2020-11-17 11:01 rjm123456 阅读(75) 评论(0) 推荐(0) 编辑

instr ,substr,TO_DATA

摘要：1.instr('源字符串','目标字符串’，'开始位置','第几次出现')函数select instr('BRD_SOI_standard-202011120.xml','-') from dual;--172、TO_DATA(substr('BRD_SOI_standard-202011120. 阅读全文

posted @ 2020-11-17 10:55 rjm123456 阅读(95) 评论(0) 推荐(0) 编辑