Difference between revisions of "NEXTVAL"

Revision as of 17:38, 8 December 2009

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

// config.db
set sql to recital
set sql on
// end of config.db
 
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