请问在Oracle9i里如何用存储过程实现多数据插入？

Question

如INSERT INTO FIA10(               FIA10007,FIA10008,FIA10009,
                                   FIA10010,FIA10011,FIA10012,FIA10013，FIA10014)
                 VALUES(?,?,?,
                        ?,?,?,SYSDATE，FIA10014) 其中FIA10007,FIA10008,FIA10009,FIA10010,FIA10011,FIA10012是从另外一个表FIA09复制插入的多条记录，而FIA10013是一条数据库系统时间，FIA10014是客户端提交的数据（在多条记录中是重复的）。请问如何用存储过程实现多数据插入

Answer 1

INSERT INTO FIA10(              FIA10007,FIA10008,FIA10009, 
                                  FIA10010,FIA10011,FIA10012,FIA10013，FIA10014) 
 select FIA10007,FIA10008,FIA10009,FIA10010,FIA10011,FIA10012,SYSDATE,FIA10014
   from FIA09

Answer 2

Jane_64 兄，我这里面还有一个条件阿
FIA10014 是客户端输入的，如何在select 子句查询中体现出来呢

Answer 3

对要插入的表FIA09的每一条数据是一样的吗

Answer 4

可以这样写吗？INSERT INTO FIA10(              FIA10007,FIA10008,FIA10009, 
                                  FIA10010,FIA10011,FIA10012,FIA10013，FIA10014) 
select FIA10007,FIA10008,FIA10009,FIA10010,FIA10011,FIA10012,SYSDATE,？
  from FIA09
然后用程序输入?的参数？

Answer 5

CREATE OR REPLACE PROCEDURE xxx(
  v_FIA10014 varchar
)
is
begin
  INSERT INTO FIA10(FIA10007,FIA10008,FIA10009, 
          FIA10010,FIA10011,FIA10012,FIA10013，FIA10014) 
    select FIA10007,FIA10008,FIA10009,FIA10010,FIA10011,FIA10012,SYSDATE,v_FIA10014 
      from FIA09;
end xxx;