SQL一次性安插多条记录

insert into book(id, name) values (1, '冰与火之歌'),(2, '动物庄园')

insert into book(id,name) select 1, '冰与火之歌' from dual union select 2, '动物庄园'  from dual

insert into book(id, name) select seq.nextval, name from (select '冰与火之歌' as name from dual union select '动物庄园' as name from dual)