Oracle10g insert 多条数据

来源：互联网发布：淘宝照片怎么拍好看编辑：程序博客网时间：2024/05/16 16:56

这次做练习向insert多条数据，在网上找了一下，很多都报错，可能是数据库版本的问题吧，我是用的方法是这样的：

<span style="font-size:24px;"><span style="font-family:Comic Sans MS;font-size:24px;">insert into loan_person  (PERSON_ID, PERSON_NAME, ID_CARD, REG_AREA, NOTE)select '4', '2', '3', '4', '5' from dual union allselect '2', '3', '4', '5','6' from dual union allselect '3','4', '5' ,'6', '7' from dual ;

以下这几种都报错了：

<span style="font-size:24px;">insert into loan_person  (PERSON_ID, PERSON_NAME, ID_CARD, REG_AREA, NOTE)values  ('4', '2', '3', '4', '5'),  ('2', '3', '4', '5','6' ),  ('3','4', '5' ,'6', '7' );

<span style="font-size:24px;">insert into loan_person  (PERSON_ID, PERSON_NAME, ID_CARD, REG_AREA, NOTE)select '4', '2', '3', '4', '5' union allselect '2', '3', '4', '5','6' union allselect '3','4', '5' ,'6', '7' ;

0 0