SQL>  select  test22.addr,test2.* from test2 right join test22 on  test2.id=test22.id;

ADDR                         ID NAME
-------------------- ---------- --------------------
shanghai                      1 shen
beijing                       2 liang
nanjing                       3 hello
tianjing

SQL>  select  test22.addr,test2.* from test2,test22 where test2.id(+)=test22.id;

ADDR                         ID NAME
-------------------- ---------- --------------------
shanghai                      1 shen
beijing                       2 liang
nanjing                       3 hello
tianjing

SQL> select * from test22;

        ID ADDR
---------- --------------------
         1 shanghai
         2 beijing
         3 nanjing
        10 tianjing

SQL> select * from test2;

        ID NAME
---------- --------------------
         1 shen
         2 liang
         3 hello
         4 word
         5 java
         6 delphi
         7 c#
         8 Grails

已选择8行。