假如剛剛打開(kāi)一個(gè)會(huì)話 ,例如用PL/SQL developer打開(kāi)一個(gè)command窗口 執(zhí)行一個(gè) SQL> create sequence seq_test_id start with 1;Sequence createdSQL> select seq_test_id.currval from dual; select seq_test_id.currval from dualORA-08002: sequence SEQ_TEST_ID.CURRVAL is not yet defined in this session這時(shí)會(huì)告訴你 sequence SEQ_TEST_ID.CURRVAL is not yet defined in this session 顯然SEQ_TEST_ID當(dāng)前是存在的，而其sequence對(duì)象應(yīng)該也和session無(wú)關(guān). 如何解決這個(gè)問(wèn)題 呢 ？？ 只需要執(zhí)行 SQL> select seq_test_id.nextval from dual; NEXTVAL ---------- 1SQL> select seq_test_id.currval from dual; CURRVAL ---------- 1原來(lái)在查看sequence對(duì)象的currval值的時(shí)候，必須先要調(diào)用它的nextval，實(shí)在是沒(méi)道理的很把，可Oracle就是如此？？ oracle樂(lè)于無(wú)故增加學(xué)習(xí)成本阿 /呵呵 只要新打開(kāi)一個(gè)command的窗口，也就會(huì)有類似問(wèn)題，所以記住這個(gè)特性就夠啦 oracle的錯(cuò)誤碼也有官方表達(dá)ORA-08002: sequence string.CURRVAL is not yet defined in this session Cause: sequence CURRVAL has been selected before sequence NEXTVAL Action: select NEXTVAL from the sequence before selecting CURRVAL Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1446746
