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
转载于:https://www.cnblogs.com/Gracedream/archive/2011/07/25/2116186.html