Difference between revisions of "NEXTVAL"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 19: | Line 19: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | 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 | |
| − | 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 | + | |
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Pseudo Columns]] | [[Category:Pseudo Columns]] | ||
Latest revision as of 14:58, 4 July 2011
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
