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
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