BEGIN
generate_tmpsht;
execute immediate
'insert into SHTSUPPLIERRATE (supplierid,supplierrate,supplierdialcode)
select :var_TMPSupplier1ID,:var_TMPSupplier1Rate,:var_TMPSupplier1DialCode from dual
union all select :var_TMPSupplier2ID,:var_TMPSupplier2Rate,:var_TMPSupplier2DialCode from dual
union all select :var_TMPSupplier3ID,:var_TMPSupplier3Rate,:var_TMPSupplier3DialCode from dual
union all select :var_TMPSupplier4ID,:var_TMPSupplier4Rate,:var_TMPSupplier4DialCode from dual
union all select :var_TMPSupplier5ID,:var_TMPSupplier5Rate,:var_TMPSupplier5DialCode from dual
union all select :var_TMPSupplier6ID,:var_TMPSupplier6Rate,:var_TMPSupplier6DialCode from dual
union all select :var_TMPSupplier7ID,:var_TMPSupplier7Rate,:var_TMPSupplier7DialCode from dual
union all select :var_TMPSupplier8ID,:var_TMPSupplier8Rate,:var_TMPSupplier8DialCode from dual
union all select :var_TMPSupplier9ID,:var_TMPSupplier9Rate,:var_TMPSupplier9DialCode from dual
union all select :var_TMPSupplier10ID,:var_TMPSupplier10Rate,:var_TMPSupplier10DialCode from dual
union all select :var_TMPSupplier11ID,:var_TMPSupplier11Rate,:var_TMPSupplier11DialCode from dual
union all select :var_TMPSupplier12ID,:var_TMPSupplier12Rate,:var_TMPSupplier12DialCode from dual
union all select :var_TMPSupplier13ID,:var_TMPSupplier13Rate,:var_TMPSupplier13DialCode from dual
union all select :var_TMPSupplier14ID,:var_TMPSupplier14Rate,:var_TMPSupplier14DialCode from dual
union all select :var_TMPSupplier15ID,:var_TMPSupplier15Rate,:var_TMPSupplier15DialCode from dual
union all select :var_TMPSupplier16ID,:var_TMPSupplier16Rate,:var_TMPSupplier16DialCode from dual
union all select :var_TMPSupplier17ID,:var_TMPSupplier17Rate,:var_TMPSupplier17DialCode from dual
union all select :var_TMPSupplier18ID,:var_TMPSupplier18Rate,:var_TMPSupplier18DialCode from dual
union all select :var_TMPSupplier19ID,:var_TMPSupplier19Rate,:var_TMPSupplier19DialCode from dual
union all select :var_TMPSupplier20ID,:var_TMPSupplier20Rate,:var_TMPSupplier20DialCode from dual
union all select :var_TMPSupplier11ID,:var_TMPSupplier21Rate,:var_TMPSupplier21DialCode from dual
union all select :var_TMPSupplier22ID,:var_TMPSupplier22Rate,:var_TMPSupplier22DialCode from dual
union all select :var_TMPSupplier23ID,:var_TMPSupplier23Rate,:var_TMPSupplier23DialCode from dual
union all select :var_TMPSupplier24ID,:var_TMPSupplier24Rate,:var_TMPSupplier24DialCode from dual
union all select :var_TMPSupplier25ID,:var_TMPSupplier25Rate,:var_TMPSupplier25DialCode from dual
union all select :var_TMPSupplier26ID,:var_TMPSupplier26Rate,:var_TMPSupplier26DialCode from dual
union all select :var_TMPSupplier27ID,:var_TMPSupplier27Rate,:var_TMPSupplier27DialCode from dual
union all select :var_TMPSupplier28ID,:var_TMPSupplier28Rate,:var_TMPSupplier28DialCode from dual
union all select :var_TMPSupplier29ID,:var_TMPSupplier29Rate,:var_TMPSupplier29DialCode from dual
union all select :var_TMPSupplier30ID,:var_TMPSupplier30Rate,:var_TMPSupplier30DialCode from dual'
using var_TMPSupplier1ID
,var_TMPSupplier1Rate
,var_TMPSupplier1DialCode
,var_TMPSupplier2ID
,var_TMPSupplier2Rate
,var_TMPSupplier2DialCode
,var_TMPSupplier3ID
,var_TMPSupplier3Rate
,var_TMPSupplier3DialCode
,var_TMPSupplier4ID
,var_TMPSupplier4Rate
,var_TMPSupplier4DialCode
,var_TMPSupplier5ID
,var_TMPSupplier5Rate
,var_TMPSupplier5DialCode
,var_TMPSupplier6ID
,var_TMPSupplier6Rate
,var_TMPSupplier6DialCode
,var_TMPSupplier7ID
,var_TMPSupplier7Rate
,var_TMPSupplier7DialCode
,var_TMPSupplier8ID
,var_TMPSupplier8Rate
,var_TMPSupplier8DialCode
,var_TMPSupplier9ID
,var_TMPSupplier9Rate
,var_TMPSupplier9DialCode
,var_TMPSupplier10ID
,var_TMPSupplier10Rate
,var_TMPSupplier10DialCode
,var_TMPSupplier11ID
,var_TMPSupplier11Rate
,var_TMPSupplier11DialCode
,var_TMPSupplier12ID
,var_TMPSupplier12Rate
,var_TMPSupplier12DialCode
,var_TMPSupplier13ID
,var_TMPSupplier13Rate
,var_TMPSupplier13DialCode
,var_TMPSupplier14ID
,var_TMPSupplier14Rate
,var_TMPSupplier14DialCode
,var_TMPSupplier15ID
,var_TMPSupplier15Rate
,var_TMPSupplier15DialCode
,var_TMPSupplier16ID
,var_TMPSupplier16Rate
,var_TMPSupplier16DialCode
,var_TMPSupplier17ID
,var_TMPSupplier17Rate
,var_TMPSupplier17DialCode
,var_TMPSupplier18ID
,var_TMPSupplier18Rate
,var_TMPSupplier18DialCode
,var_TMPSupplier19ID
,var_TMPSupplier19Rate
,var_TMPSupplier19DialCode
,var_TMPSupplier20ID
,var_TMPSupplier20Rate
,var_TMPSupplier20DialCode
,var_TMPSupplier21ID
,var_TMPSupplier21Rate
,var_TMPSupplier21DialCode
,var_TMPSupplier22ID
,var_TMPSupplier22Rate
,var_TMPSupplier22DialCode
,var_TMPSupplier23ID
,var_TMPSupplier23Rate
,var_TMPSupplier23DialCode
,var_TMPSupplier24ID
,var_TMPSupplier24Rate
,var_TMPSupplier24DialCode
,var_TMPSupplier25ID
,var_TMPSupplier25Rate
,var_TMPSupplier25DialCode
,var_TMPSupplier26ID
,var_TMPSupplier26Rate
,var_TMPSupplier26DialCode
,var_TMPSupplier27ID
,var_TMPSupplier27Rate
,var_TMPSupplier27DialCode
,var_TMPSupplier28ID
,var_TMPSupplier28Rate
,var_TMPSupplier28DialCode
,var_TMPSupplier29ID
,var_TMPSupplier29Rate
,var_TMPSupplier29DialCode
,var_TMPSupplier30ID
,var_TMPSupplier30Rate
,var_TMPSupplier30DialCode ;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
相关推荐
oracle之dual表的一些 oracle之dual表的一些 oracle之dual表的一些
此脚本介绍了使用过程插入多条(最多100000000)数据的方法,是oracle入门的宝贵资源,在sqlplus中使用@+路径+文件名来执行;如:@E:\procedure.sql
Oracle左连接返回多条记录中一条记录的查询语句,更具指定条件分组排序,返回各组中第一条记录
我想往数据库插入多条数据时,使用了如下语句: insert into 表1 (字段1,字段2) values (1,2),(2,3),(3,4); 这条语句在mysql中执行的话,语法一点毛病都没有,但是,在oracle上执行一直报错: ORA-00933: SQL ...
Oracle批处理:使用C# 自带Oracle驱动一次执行多条Sql语句
详解Oracle数据库中DUAL表的使用
dual是一个虚拟表,用来构成select的语法规则,oracle保证dual里面永远只有一条记录
主要介绍了Oracle中多表关联批量插入,批量更新与批量删除操作,本文通过实例代码给大家介绍的非常详细,具有一定的参考借鉴价值,需要的朋友可以参考下
如何在Oracle数据表中随机抽取部分记录的方法
java批量插入方法代码和一些注释
表结构的创建比较简单,但是表的数据量太大,一时也想不到怎么把sqlserver表数据复制到oracle中,于是请教公司主管,用存储过程实现可以查询出所有数据的insert脚本,在oracle库中创建好表,直接把sqlserver中的...
Oracle多行记录合并/连接/聚合字符串的几种方法
Oracle 一次请求执行多条sql语句 在.net 中查询Sql Server 一次请求执行多条sql语句很简单 拼接起来就好了 初次接触oracle 在网上寻找了很多方法终于被我解决了 我把问题想复杂了 例子中提供了2种解决方案 一种...
一个选查询后插入到一个临时表的oracle函数
Java实现使用Mybatis将数据批量插入到Oracle数据库,并且可以使用Oracle序列来生成主键
[Oracle]在亿级记录表中创建索引 [Oracle]如何在亿级记录表中创建索引 [Oracle]如何在亿级记录表中创建索引
使用oracle数据库时修改表结构,创建表空间等等
ORACLE 数据库中如何统计表记录数的过程说明
例如: 两表(多表)关联update -- 仅在where字句中的连接 --这次提取的数据都是VIP,且包括新增的,所以顺便更新客户类别 update customers a -- 使用别名 set customer_type='01' --01 为vip,00为普通 where ...