DECLARE newID varchar2(50);
begin
insert into table1 (aa,bb) values('7777','8888') RETURNING ID INTO newID;
COMMIT;
insert into table2 (pid) values(newID);
end;
转载于:https://www.cnblogs.com/yuany69/p/6210087.html
oracle 得到新插入数据的ID并使用
DECLARE newID varchar2(50);
begin
insert into table1 (aa,bb) values('7777','8888') RETURNING ID INTO newID;
COMMIT;
insert into table2 (pid) values(newID);
end;
转载于:https://www.cnblogs.com/yuany69/p/6210087.html
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
