摘要:
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... 阅读全文