Any reference to CURRVAL always returns the sequence’s current value, which is the value returned by the last reference to NEXTVAL.Note that before you use CURRVAL for a sequence in your
session, you must first initialize the sequence with NEXTVAL.
session, you must first initialize the sequence with NEXTVAL.
解决方案 »
- 关于 order by 子句里面用到 case when 的例子
- 如果 name是oracle的关键字 但是我的表里有name这个字段 我怎么查询 name啊
- 急!!oracle导入导出问题,弄了半天了
- 执行SQL报ORA-03113: end-of-file on communication channel错误,各位大侠,请帮忙看看!
- 动态db_link:将db_link作为参数传入存储过程如何使用。
- linux as 4自动启动多个oracle
- 求教dbms_output.put_line中如何输出制表符等特殊字符?
- oracle入门
- ora-03114怎么解决
- MERGE INTO效率很低
- 关于asp连接oracle数据库的问题, 很急,请高手帮忙
- 兼职开发oracle+delphi软件
是不是sequence坏了,还是它在不同的session中有不同的值。是不是用select seq_name.nextval from dual;
也会增加sequence的值thanks!
BEFORE INSERT ON t_books_series
FOR EACH ROWBEGIN
SELECT seq_books_series_id.NEXTVAL INTO :new.id FROM dual;
END;再进行上面的操作是不是会自加呢?我的实践结果是会自加!
WHY ? ? ?
SELECT seq_books_series_id.NEXTVAL FROM dual;
SELECT seq_books_series_id.CURRVAL FROM dual;e.g _---------->errorcommit;
SELECT seq_books_series_id.CURRVAL FROM dual;