SQL> select * from a;
A ---------- 1 2 3 4 SQL> select * from b; A B C ---------- ---------- ---------- 1 4 10 2 5 11 5 6 12 6 7 13 SQL>select A.a,B.A,B.b,b.c from A,B where A.a=B.a; A A B C ---------- ---------- ---------- ---------- 1 1 4 10 2 2 5 11 SQL>select A.a,B.A,B.b,b.c from A,B where A.a=B.a(+); A A B C ---------- ---------- ---------- ---------- 1 1 4 10 2 2 5 11 3 4 SQL>select A.a,B.A,B.b,b.c from A,B where A.a=B.a(+) and b.c>10; A A B C ---------- ---------- ---------- ---------- 2 2 5 11 SQL>select A.a,B.A,B.b,b.c from A,B where A.a=B.a(+) and b.c(+)>10; A A B C ---------- ---------- ---------- ---------- 1 2 2 5 11 3 4 |
|