语法没有错误:
SQL> ed
Wrote file afiedt.buf
1* CREATE SEQUENCE seq INCREMENT BY 1 START WITH 1 MAXVALUE 999
SQL> /Sequence created.SQL> ed
Wrote file afiedt.buf
1 declare
2 aaa number;
3 begin
4 select seq.nextval into aaa from dual;
5* end;
SQL> /PL/SQL procedure successfully completed.
SQL> ed
Wrote file afiedt.buf
1* CREATE SEQUENCE seq INCREMENT BY 1 START WITH 1 MAXVALUE 999
SQL> /Sequence created.SQL> ed
Wrote file afiedt.buf
1 declare
2 aaa number;
3 begin
4 select seq.nextval into aaa from dual;
5* end;
SQL> /PL/SQL procedure successfully completed.
INCREMENT BY 1
START WITH 1
MAXVALUE 999;
序列已创建。
create procedure pr_test
is
aaa number;
begin
select seq.nextval into aaa from dual;
end;
过程已创建。
commit;
提交完成。
execute pr_test;
PL/SQL 过程已成功完成。
执行
delete from dual;
select seq.nextval from dual;
看看.