- CREATE TABLE sample (
- id INTEGER,
- value VARCHAR(50),
- PRIMARY KEY(id)
- );
- CREATE SEQUENCE sample_id_sequence
- start with 1
- increment by 1
- nomaxvalue
- ;
- CREATE TRIGGER sample_id_increment_trigger
- before INSERT
- ON sample
- FOR each ROW
- begin
- SELECT sample_id_sequence.nextval INTO :new.id FROM dual;
- end
- ;
- /