close

.     選單的TABLE在control table中，

 

l          F9000

l          F9001

l          F9002

l          F9005

l          F9005D

l          F9006

l          F9006D

此次測試計畫將sim1複製到test(DV900)中，語法如下：

truncate table sim1ctl.F9000;

truncate table sim1ctl.F9001;

truncate table sim1ctl.F9002;

truncate table sim1ctl.F9005;

truncate table sim1ctl.F9005D

truncate table sim1ctl.F9006;

truncate table sim1ctl.F9006D;

==============================

 

insert into testctl.F9000 select * from sim1ctl.F9000;
insert into testctl.F9001 select * from sim1ctl.F9001;
insert into testctl.F9002 select * from sim1ctl.F9002;
insert into testctl.F9005 select * from sim1ctl.F9005;
insert into testctl.F9005D select * from sim1ctl.F9005D;
insert into testctl.F9006 select * from sim1ctl.F9006;
insert into testctl.F9006D select * from sim1ctl.F9006D;

===========================================

commit;

arrow
arrow
    全站熱搜

    masterman 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄