JavaCoderWolf的博客

ORACLE MERGE INTO DELETE注意源表和目标表数据都要唯一merge into PERSONCERTIFICATEBAK busing (select ids from person_cer_dele ) uon (b.id = u.ids)when matched then update set b.personguid = b.personguiddelet...

生成执行计划explain plan for select * from xxxx where xxx = xxx;查看索引使用明细select * from table(dbms_xplan.display);