![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
还是要努力啊
17年11月实习
展开
-
ORACLE MERGE INTO DELETE
ORACLE MERGE INTO DELETE 注意源表和目标表数据都要唯一 merge into PERSONCERTIFICATEBAK b using (select ids from person_cer_dele ) u on (b.id = u.ids) when matched then update set b.personguid = b.personguid delet...原创 2019-08-14 10:38:39 · 2216 阅读 · 0 评论 -
oracle sql语句索引使用情况 查询
生成执行计划 explain plan for select * from xxxx where xxx = xxx; 查看索引使用明细 select * from table(dbms_xplan.display);原创 2019-05-17 09:52:20 · 2601 阅读 · 0 评论