数据库批量数据插入
数据库类型:oracle
insert all
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','01','西安市非住宅改建为租赁住房项目申请审核表',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','02','营业执照',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','03','法定代表人或其他组织主要负责人有效身份证明',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','04','房屋权属证明材料',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','05','项目改建方案',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','06','房屋安全检测报告',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','07','所有他项权利人同意改建的书面意见',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','08','书面承诺',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','09','委托代理人身份证明',10,1)
into zl_cs_yjlx (ywlx,yjlxdm,yjlxmc,zdsl,sfbx) values ('XMFL_GJXM_WT','10','授权委托书',10,1)
select 1 from dual;
数据库类型:mysql
浙公网安备 33010602011771号