1.是的,用curval只能取得整个序列的curval。如果你想保持各会话的独立,可以放到一个变量里面。
2.你可以用select 1,RowsID,s_tt_temp_id.nextval
from (select 1, RowsID, ReceiptCount
FROM TT_TEMP_RECEIPTNUMINFO;
ORDER BY RowsID) ;
2.你可以用select 1,RowsID,s_tt_temp_id.nextval
from (select 1, RowsID, ReceiptCount
FROM TT_TEMP_RECEIPTNUMINFO;
ORDER BY RowsID) ;
sql>select some_seq.currval from dual,
*
ERROR 位于第 1 行:
ORA-08002: 序列SOME_SEQ.CURRVAL 尚未在此进程中定?
SQL> select some_seq.nextval from dual; NEXTVAL
----------
1SQL> select pbc001_seq.currval from dual CURRVAL
----------
1
2,类似查询是oracle的问题.在8i以上的可以,805及805以下的不可以.