CREATE SEQUENCE station_id INCREMENT BY 1 START WITH 0 MINVALUE 1 MAXVALUE 999999999999999999999999999 NOCYCLE NOORDER CACHE 20CREATE OR REPLACE TRIGGER insert_station_id BEFORE INSERT ON s_station_info REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW begin select create_station_id.nextval into :new.station_id from dual; end;
INCREMENT BY 1
START WITH 0
MINVALUE 1
MAXVALUE 999999999999999999999999999
NOCYCLE
NOORDER
CACHE 20CREATE OR REPLACE TRIGGER insert_station_id
BEFORE INSERT
ON s_station_info
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
begin
select create_station_id.nextval into :new.station_id from dual;
end;