1、创建测试表,
create table test_aaa( value varchar2(20));
create table test_bbb( value varchar2(20));
2、插入测试数据
insert into test_aaa values ('abcd');
insert into test_bbb values ('efgh');
commit;
3、查询表中数据,select t.* from test_aaa t union all select t.* from test_bbb t;
4、编写sql,拼接两张表的记录;
select a.value||b.value value from test_aaa a, test_bbb b;