如果时pl/sql程序
SQL> set serveroutput on
SQL> declare
2 i number;
3 begin
4 select test.nextval into i from dual;
5 dbms_output.put_line('i=' || i || ';');
6 end;
7 /
i=6;PL/SQL procedure successfully completed.
SQL> set serveroutput on
SQL> declare
2 i number;
3 begin
4 select test.nextval into i from dual;
5 dbms_output.put_line('i=' || i || ';');
6 end;
7 /
i=6;PL/SQL procedure successfully completed.
select sequence.nextval from dual
之后再使用
select sequence.currval from dual,
这样可以得到1后面的值2