语法没有错误:
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.
解决方案 »
- exp导出的10g的数据库可以恢复到11g么
- ORA-12518: TNS: 监听程序无法分发客户机连接
- 客户端连服务器时而没问题,时而报“ORA-12545因目标主机或对象不存在,连接失败”
- 写一个job每天晚上1:00 钟执行一个存储过程?
- select 售价/sum(售价) from 表
- 关于SQL语句中:ROWNUM的奇怪问题.
- Oracle连接的问题,高手请入!!
- 问个简单的问题,exp和Imp这两个命令在哪里执行呀
- 在Oracle中 用varchar2做主键或索引对系统性能有无不良影响?
- 请教高手,SQL问题
- 请教几个SQL问题~急,在线等~~请高手指教
- [问题] 再请教一个Oracle中关于sql的问题?
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;
看看.