What's the different between left joint and right joint in PLSQL?
You can see the different between left joint and right joint by a simple example!
[@more@]SQL> SELECT * FROM T_0918;
ID T_A
---------- ----------
1 A1
2 A2
4 A4
SQL> SELECT * FROM T_0918_2;
ID T_B
---------- ----------
1 B1
2 B2
3 B3
SQL> SELECT T_A,T_B FROM T_0918,T_0918_2
2 WHERE T_0918.ID(+)=T_0918_2.ID;
T_A T_B
---------- ----------
A1 B1
A2 B2
B3
SQL> SELECT T_A,T_B FROM T_0918,T_0918_2
2 WHERE T_0918.ID=T_0918_2.ID(+);
T_A T_B
---------- ----------
A1 B1
A2 B2
A4
SQL> SELECT T_A,T_B FROM T_0918,T_0918_2
2 WHERE T_0918.ID=T_0918_2.ID;
T_A T_B
---------- ----------
A1 B1
A2 B2
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10484922/viewspace-969829/ ，如需转载，请注明出处，否则将追究法律责任。
