Oracle

NEXTVAL and CURRVAL Pseudocolumns : Rules

Figo Kim 2006. 11. 25. 22:00
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

Rules for using NEXTVAL and CURRVAL
You can use NEXTVAL and CURRVAL in the following contexts:

  • The SELECT list of a SELECT statement that is not part of a subquery
  • The SELECT list of a subquery in an INSERT statement
  • The VALUES clause of an INSERT statement
  • The SET clause of an UPDATE statement

    You cannot use NEXTVAL and CURRVAL in the following context:


  • The SELECT list of a view
  • A SELECT statement with the DISTINCT keyword
  • A SELECT statement with GROUP BY, HAVING, or ORDER BY clause
  • A subquery in a SELECT ,DELETE, or UPDATE statement
  • The DEFAULT expression in a CREATE TABLE or ALTER TABLE statement

'Oracle' 카테고리의 다른 글

Using a Sequence  (0) 2006.11.26
Using a Sequence  (0) 2006.11.26
NEXTVAL and CURRVAL Pseudocolumns : Rules  (0) 2006.11.25
Sequence  (0) 2006.11.25
Sequence  (0) 2006.11.25