Oracle

NEXTVAL and CURRVAL Pseudocolumns

Figo Kim 2006. 9. 5. 21:16
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
  • NEXTVAL : The NEXTVAL pseudocolumns is used to extract successive sequence numbers from a specified sequence.
    sequence.NEXTVAL
  • CURRVAL : The CURRVAL pseudocolumn is used to refer to a sequence number that the current user has just generated.

After you generated a sequence object, you have to call NEXTVAL first because the initiatied pointer of the sequence object is pointing the head of the object which has NULL.

'Oracle' 카테고리의 다른 글

무지에서 오는 고통..(손상된 디비 복구하기)  (0) 2006.09.12
NEXTVAL and CURRVAL Pseudocolumns  (0) 2006.09.05
Database Objects  (0) 2006.09.04
Database Objects  (0) 2006.09.04
ALTER TABLE statement  (0) 2006.09.03