oracle中join的用法

[lusemaomaochong]

sql server中可以用join，将多张表的数合并为一张表，请问oracle是否也能用join。请给一个具体例子

[pengdali]

8i:

create table dali.test1(a int,b int);
create table dali.test2(a int,b int);

insert into dali.test1 values(1,456);
insert into dali.test1 values(2,427);
insert into dali.test2 values(1,45456);
insert into dali.test2 values(3,45656);

---内连接
select * from dali.test1 a, dali.test2 b where a.a=b.a;

---左连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+);

---右连接
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---完全连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+)
union
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---迪卡尔
select * from dali.test1, dali.test2;

[pengdali]

9i和sqlserver一样 left join,right join,full join