insert into select 语句

1、insert into jzcd_mdoc_type(id,branch_id,doc_type_id) select S_JZCD_MDOC_TYPE.NEXTVAL, branch_id,175 from jzcd_basic_info

zcd_mdoc_type 表真实存在，branch_id字段值来自jzcd_basic_info表，S_JZCD_MDOC_TYPE.NEXTVAL来自数据库序列化字段，175常量值

2、select value1,value2 into table2 from table1

要求table2表不存在

 

今天又一次用到1的情况：

insert into jzcd_doc_type

(id,branch_id,doc_type_id,count,required_flag,count_flag,pick_

level,pick_type,baoquan_flag)
select S_JZCD_DOC_TYPE.NEXTVAL, branch_id,'193',

1,'Y','Y',1,'1','N' from  jzcd_basic_info;
commit;