Oracle数据库 | 您所在的位置:网站首页 › Oracle的insert怎么写 › Oracle数据库 |
oracle的批量插入方式有多种,以下具体讲讲 方式1insert all into oracle_table ( id, code ) values( 1 , '1' ) into oracle_table ( id, code ) values( 2 , '2' ) into oracle_table ( id, code ) values( 3 , '3' ) into oracle_table ( id, code ) values( 4 , '4' ) select 1 from dual ; 此种方式,看起来比较简洁 方式2insert into oracle_table (id,code) select id,code from ( select 1 as id, '1' as code from dual union all select 1 as id, '1' as code from dual union all select 1 as id, '1' as code from dual union all select 1 as id, '1' as code from dual ) ; 使用union all 拼接批量数据,然后使用insert into 方法插入拼接好的数据 方式3begin insert into oracle_table ( id, code ) values( 1 , '1' ); insert into oracle_table ( id, code ) values( 2 , '2' ); insert into oracle_table ( id, code ) values( 3 , '3' ); insert into oracle_table ( id, code ) values( 4 , '4' ); end; 用语句块来执行批量语句 |
CopyRight 2018-2019 实验室设备网 版权所有 |