笛卡尔积与全连接

建表：
create table test111 (id number,name varchar2(20));
create table test222 (id number,name varchar2(20));

insert into test111 values(111,'aaa');
insert into test111 values(222,'bbb');
insert into test111 values(444,'ddd');

insert into test222 values(222,'bbb');
insert into test222 values(333,'ccc');
insert into test222 values(444,'eee');
insert into test222 values(444,'fff');
commit;

笛卡尔积
select * from test111,test222;

       111 aaa                         222 bbb
       111 aaa                         333 ccc
       111 aaa                         444 eee
       111 aaa                         444 fff
       222 bbb                         222 bbb
       222 bbb                         333 ccc
       222 bbb                         444 eee
       222 b