orcale批量录入

select * from  tabs
drop table ycoms_retroaction
create table YCOMS_RETROACTION
(
  RETROACTIONID  VARCHAR2(32) not null,
  TASKID         VARCHAR2(20),
  TASKCRETER     VARCHAR2(8),
  TASKMAINDUTYER VARCHAR2(8),
  WEEKLOGID      VARCHAR2(20),
  APPSTATUS      VARCHAR2(2),
  CREATER        VARCHAR2(8),
  CREATTIME      VARCHAR2(25),
  EDITER         VARCHAR2(8),
  EDITTIME       VARCHAR2(25),
   primary key (RETROACTIONID)
)
INSERT INTO YCOMS_RETROACTION
  (RETROACTIONID,
   TASKID,
   TASKCRETER,
   TASKMAINDUTYER,
   WEEKLOGID,
   APPSTATUS,
   CREATER,
   CREATTIME,
   EDITER,
   EDITTIME)
  SELECT sys_guid(),
         T.TASKID,
         T.TASKCRETER,
         T.TASKMAINDUTYER,
         w.attendanceid,
         '1',
         w.actorno,
         TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF3'),
         w.actorno,
         TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.FF3')
    FROM YCOMS_TASK T, ycoms_worklog w
   WHERE T.Taskid = w.linkid
     and w.linkidtype = '04'
select * from ycoms_retroaction