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