2012年2月9日

delete/update/insert by join

摘要: //deletedelete from table1 a where exists (select 1 from table2 b where a.col1 = b.col1)//insertinsert into table1 ( col1, col2)select 'a', 'b' from dualwhere not exists (select 1 from table2 where index = ?)//updateupdate /*+ bypass_ujvc */ (select col1 from table1 a, table2b where 阅读全文

posted @ 2012-02-09 14:48 Kevin Kim 阅读(215) 评论(0) 推荐(0) 编辑

导航