oracle 中 插入多条

INSERT INTO as_areas (id, parent_id, area_name, zipcode) select
'952','88', '公主岭市', '136100' from dual  union select
'953','88', '双辽市', '136400' from dual

posted @ 2014-10-09 10:12  mr.g.  阅读(168)  评论(0)    收藏  举报