<insert id ="insertColumn" parameterType="java.util.List" >
insert into T_META_COLUMN(COL_ID,COL_EN,TAB_ID,FMT_LEN,NULL_FG,COL_TP,COL_NO,SYS_ID,DB_ID)
select 'C'||SEQ_META_COLUMN.NEXTVAL, A.* FROM(
<foreach collection ="list" item="metaColumn" index= "index" separator ="UNION ALL">
select #{metaColumn.colEn},#{metaColumn.tabId},#{metaColumn.fmtLen},#{metaColumn.nullFg},#{metaColumn.colTp},#{metaColumn.colNo},#{metaColumn.sysId},#{metaColumn.dbId}from dual
</foreach>
) A
</insert >
insert into T_META_COLUMN(COL_ID,COL_EN,TAB_ID,FMT_LEN,NULL_FG,COL_TP,COL_NO,SYS_ID,DB_ID)
select 'C'||SEQ_META_COLUMN.NEXTVAL, A.* FROM(
<foreach collection ="list" item="metaColumn" index= "index" separator ="UNION ALL">
select #{metaColumn.colEn},#{metaColumn.tabId},#{metaColumn.fmtLen},#{metaColumn.nullFg},#{metaColumn.colTp},#{metaColumn.colNo},#{metaColumn.sysId},#{metaColumn.dbId}from dual
</foreach>
) A
</insert >