摘要:
with tmp as(select '1' id ,'aa' name ,'22' age from dual union allselect '2' id ,'bb' name ,'20' age from dual union allselect '3' id ,'CC' name ,'21' age from dual)select a.*, lead(age,1) over ... 阅读全文
摘要:
执行如下sql语句,可对之前删掉的数据回滚: Insert into CRM_ORDER select * from CRM_ORDER as of timestamp to_timestamp('2016-04-23 01:40:00','yyyy-mm-dd hh24:mi:ss') 阅读全文