oracle通過查詢靈活插入數據insertinto...select..

oracle通過查詢靈活插入數據insertinto...select..

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;