SQL脚本记录

一、自增长的插入ID
declare
  maxid Number(12);
begin

   select max(id)+1 into maxid from t_menu;
  insert into T_MENU (ID, CODE, NAME, PARENT_ID, URL, APPLICATION_ID, STATUS, WEIGHTY) values (maxid, 'Portal_MS', 'Launcher管理', 0, null, 40, 1, 36);
  
   insert into T_MENU (ID, CODE, NAME, PARENT_ID, URL, APPLICATION_ID, STATUS, WEIGHTY) values (maxid+1, 'Portal_MS', '资源管理', maxid, '/launcherRes/queryLauncherResList.action', 40, 1, 37);

   insert into T_MENU (ID, CODE, NAME, PARENT_ID, URL, APPLICATION_ID, STATUS, WEIGHTY) values (maxid+2, 'Portal_MS', '模板管理', maxid, '/launcherTemp/queryLauncherTempList.action', 40, 1, 38);
   commit;
end;