NEXTVAL

From Recital Documentation Wiki
Revision as of 14:58, 4 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Return the next unique sequence number from the specified table


Syntax

NEXTVAL


See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE


Description

A Pseudo Column behaves like a table column, but is not actually stored in the table. You can select from Pseudo Columns, but they cannot be updated. Pseudo Columns provide extra information about a SELECT row set.

The NEXTVAL Pseudo Column will return the next unique sequence number from the specified table. Sequence numbers can be used for primary and unique index keys.


Example

CREATE TABLE cust (acc_num INT , acc_name char(20))
INSERT INTO cust (acc_num, acc_name) VALUES (NEXTVAL, "Smith")
INSERT INTO cust (acc_name) VALUES ("Brown")
INSERT INTO cust (acc_num, acc_name) VALUES (CURRVAL+2, "Jones")
SELECT * from cust


Products

Recital, Recital Server