Versions available for this page: CUBRID 8.2.1 |
You can access and update a serial by serial name and a reserved word pair.
The following is an example of using serial.
First, the athlete_idx table which includes athlete codes and names is created, and one instance created by the order_no serial is inserted.
CREATE TABLE athlete_idx
(code INT, name VARCHAR(40) );
INSERT INTO athlete_idx VALUES (order_no.NEXT_VALUE, 'Park Tae-Hwan');