求助：在线等！ 怎么把几个表的数据插入到一个表

Question

这是一张目标表(TARGET)
ssNUM ssNAME            ssADDRESS     ssSCORE
---------- -------------------- ---------- ----------
         1 张三                 street1           100
         2 李四                 street2            19
         3 兆瓦                 street3            80
         4 钱五                 street4            10
         5 孙六                 street5            70
         6 周七                 street6            87
         7 吴八                 street7            88
         8 郑九                 street8            70
         9 王二                 street9           150
        10 冯十                 street1           600
        11 刘三                 street0             0
        12 刘一                 street2             6
        13 张二                 street3            60
        14 丽丽                 street4            55
        15 汤云                 street3            67
        16 菲菲                 street2           100
        17 张三                 street4            67这是第二张表  (tab1)
      NUM NAME                 SEX               AGE
---------- -------------------- ---------- ----------
         1 lyf                  male               27
         2 lili                 female             32
         3 bobo                 female             25
这是第三张表 (tab2)       NUM NAME                 SEX               AGE
---------- -------------------- ---------- ----------
        12 lyy                  male             1313
         3 lsdfy                female            100。
。
两个表的结果是这个样子的ssNUM ssNAME            ssADDRESS      ssSCORE
---------- -------------------- ---------- ----------
         1 张三                 street1           100
         2 李四                 street2            19
         3 兆瓦                 street3            80
         4 钱五                 street4            10
         5 孙六                 street5            70
         6 周七                 street6            87
         7 吴八                 street7            88
         8 郑九                 street8            70
         9 王二                 street9           150
        10 冯十                 street1           600
        11 刘三                 street0             0
        12 刘一                 street2             6
        13 张二                 street3            60
        14 丽丽                 street4            55
        15 汤云                 street3            67
        16 菲菲                 street2           100
        17 张三                 street4            67
         1 lyf                                     27
         2 lili                                    32
         3 bobo                                    25  ssNUM ssNAME       ssADDRESS   ssSCORE
---------- -------------------- ---------- ----------
        12 lyy                                   1313
         3 lsdfy                                  100请问怎么能把几个表的数据插入到第一张表里，我想用这个方法怎么不行？insert into taboflyf(ssnum, ssname, ssscore)
select num, name, age 
from mytab, mytab2;
能否用这样的方法完成这样的任务？也有这样的方法，但是如果表tabx（10000）太多，难道要写那么多代码？
insert into taboflyf(ssnum, ssname, ssscore)
(select num, name, age 
from mytab union all select num, name, age from mytab2)哪位高手指点下， 不胜感激！！

Answer 1

strSQL Varchar2(200);
  For i in 1..1000 Loop
    strSQL := 'insert into taboflyf(ssnum, ssname, ssscore) select num, name, age from mytab' || to_char(i);
    Execute immediate strSQL;
  End Loop;

Answer 2

declare
strSQL Varchar2(200);
begin
  For i in 1..1000 Loop
    strSQL := 'insert into taboflyf(ssnum, ssname, ssscore) select num, name, age from mytab' || to_char(i);
    Execute immediate strSQL;
  End Loop;
end;
/--OK