例:
create table bh1
(
bh number(10)
);
create table bh2
(
bh number(10)
);
表1:bh1
表2:bh2
insert into bh1(bh) select bh from bh2;
查询显示两个表的内容:
select * from bh1 union all select * from bh2
例:
create table bh1
(
bh number(10)
);
create table bh2
(
bh number(10)
);
表1:bh1
表2:bh2
insert into bh1(bh) select bh from bh2;
查询显示两个表的内容:
select * from bh1 union all select * from bh2