Oralce学习笔记(sql取一张表的数据插入另一张表) insert into pm_per_res_page_ele (RES_ID,ELE_TYPE_CODE,ELE_CODE,REMARKS) select per_res_page_ele_id.nextval as RES_ID, 'Menu.Left.Tree' as ELE_TYPE_CODE, menu.menu_id as ELE_CODE, menu.menu_name as REMARKS from SYS_MENU menu