建表:
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