摘要: 1.oracle (+) 含义SELECT A.id, B.IDDFROM A, BWHERE A.id(+)=B.IDD等价于SELECT A.id, B.IDDFROM A RIGHT OUTER JOIN B ON ( A.id=B.IDD)SQL> select * from A; ID VAL---------- ---------- 1 A1 2 A2SQL> select * from B; IDD VAL---------- ---------- 1 B1 3 B... 阅读全文
posted @ 2013-08-16 01:53 williamwindy 阅读(239) 评论(7) 推荐(0) 编辑