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. 阅读(163) 评论(0) 编辑收藏举报