DECLARE
newMAS_ID NUMBER;
begin
INSERT INTO MU_ALARM_STRATEGY
(MAS_ID, MAS_NAME, MAS_INSERT_TIME, MAS_UPDATE_TIME, MAS_USER_ID)
VALUES
(0,
'testtt',
to_date('2013-07-03 13:54:02', 'yyyy-mm-dd hh24:mi:ss'),
to_date('2013-07-03 13:54:02', 'yyyy-mm-dd hh24:mi:ss'),
1142)
returning MAS_ID into newMAS_ID;
insert into MU_ALARM_ITEMS values (newMAS_ID, 1, 10);
insert into MU_ALARM_ITEMS values (newMAS_ID, 2, 100);
end;
Oracle获取最新插入的字段值
最新推荐文章于 2020-12-08 10:02:17 发布