INSERT INTO tablename(ID, SITEID, NAME, DATABASEID, TABLENAME,
CATALOGID, ARTICLESTATUS, PATHREPLACEPARTOLD, PATHREPLACEPARTNEW,
NEWRECORDRULE, SQLCONDITION, STATUS,
MAPPINGCONFIG,
MEMO, PROP1, PROP2,
PROP3, PROP4, ADDUSER, ADDTIME,
MODIFYUSER, MODIFYTIME)
SELECT rownum+117 as ID, '237' as SITEID,name,'30' as DATABASEID,'CMSADMIN.BBB' as TABLENAME,
id as CATALOGID,'0' as ARTICLESTATUS,null as PATHREPLACEPARTOLD,null as PATHREPLACEPARTNEW,
null as NEWRECORDRULE,"CONCAT"(CONCAT('SITE_ID=''237'' and CHANNEL_ID=''',"TO_CHAR"(CHANNEL_ID)), '''') as SQLCONDITION,'Y' as STATUS,
'<?xml version="1.0" encoding="gb2312"?><configs> <config name="TitleUniteFlag"><![CDATA[]]></config> <config name="TitleUniteRule"><![CDATA[]]></config> <config name="ContentUniteFlag"><![CDATA[]]></config> <config name="ContentUniteRule"><![CDATA[]]></config> <config name="RedirectURLUniteFlag"><![CDATA[]]></config> <config name="RedirectURLUniteRule"><![CDATA[]]></config> <config name="DataTable"> <![CDATA[code isprimarykey datatype _rowno mapping SITE_ID N 7 1 SITE_NAME N 1 2 CHANNEL_ID N 7 3 CHANNEL_NAME N 1 4 ITLE N 1 5 Title TXT N 10 6 Content AUTHOR N 1 7 Author RELEASE_DATE N 0 8 PublishDate ]]> </config></configs>' as MAPPINGCONFIG
,NULL as MEMO,NULL as PROP1,NULL as PROP2,
NULL as PROP3,NULL as PROP4,'wyf' as ADDUSER,TO_DATE('20120425165244', 'YYYYMMDDHH24MISS') as ADDTIME,
null as MODIFYUSER,null as MODIFYTIME
from tablename1
LEFT JOIN JC_CHANNEL_EXT on ZCCATALOG."NAME"=JC_CHANNEL_EXT.CHANNEL_NAME
where SITEID='237'and CHANNEL_ID !='51502' and CHANNEL_ID !='51503'