oracle数据库中想一次插入多行数据该怎么操作?
比如:insert into mytb1
(id,name,age,address)
values
(002,'li4',20,'hebeilu'),
(003,'zhang5',22,'qihelu') ;
收起给你个例子:
insert into CSZY_DATA(id,CODENAME,NAME,DATAVALUE,CREATETIME,CSZY_TYPE)
select 3,\'GLQZZRGLXGL\',\'其中租入光缆(芯公里)\',\'0\',\'2013-02\',\'1\' from dual
UNION select 2,\'GL_GLZLXGL\',\'光缆总量(芯公里)\',\'0\',\'2013-02\',\'1\' from dual
UNION select 4,\'GL_GLZLXGL\',\'光缆总量(芯公里)\',\'0\',\'2013-02\',\'1\' from dual