declare
v_var number;
begin
update tmp_tab t set v_status=1 where a=(select a from tmp_tab where v_status=0 and rownum=1)
returning a into v_var;
commit;
dbms_output.put_line('v_var is '||v_var );
end;
应该能保证每次都不一样
v_var number;
begin
update tmp_tab t set v_status=1 where a=(select a from tmp_tab where v_status=0 and rownum=1)
returning a into v_var;
commit;
dbms_output.put_line('v_var is '||v_var );
end;
应该能保证每次都不一样
select sid from v$mystat where rownum=1;
select userenv('sid') from dual;