日期:2014-05-17 浏览次数:20746 次
DECLARE
V_SEQID NUMBER;
BEGIN
SELECT SEQ_QQGROUP_ID.NEXTVAL INTO V_SEQID FROM DUAL;
Insert into T_BD_GROUPHEADER
(GH_ID,
GH_Name,
GH_TYPE,
GH_LOGO,
GH_SUMMARY,
GH_NOTICE_RTF,
GH_OP_ID_CREATOR,
GH_CREATOR_NAME)
Values
(V_SEQID,
'江正(1001286) 创建的讨论组',
'2',
NULL,
'江正(1001286) 创建于 08月-02日',
NULL,
'828',
'江正');
INSERT INTO T_BD_GROUPLINE
(OP_ID, GH_ID, GL_OP_ALIAS)
Select 828, V_SEQID, '江正(1001286)'
FROM DUAL
UNION
Select 1474, V_SEQID, '陈维(1002392)'
FROM DUAL
UNION
Select 726, V_SEQID, '姚婕(1001068)'
FROM DUAL
UNION
Select 13, V_SEQID, '张莉(1000013)'
FROM DUAL
UNION
Select 468, V_SEQID, '庄艳(1000611)' FROM DUAL;
COMMIT;
END;