insert into reg_user (id,name,password,area_code,reg_time,first_pswd,record_type)
select l.reg_user_id,l.entry_person,'4QrcOUm6Wau+VuBX8g+IPg==',l.area_code,sysdate,'123456',l.type
from location_info l where l.type=5;oracle 通过查询灵活插入数据 insert into ...select..
原文：http://blog.csdn.net/without0815/article/details/38818847