Create a table, sequence, and trigger in oracle

Create table "JCMS_ADVERT" ("ID" integer not null enable, "SITEID" INTEGER, "NAME" VARCHAR2 (150 CHAR) not null enable, "UPDATETIME" DATE, primary key ("ID"); create Table sequence create sequence seq_advert minvalue 1 maxvalue 9999999999999999999999999999 increment by 1 start with 1 cache 20 noorder nocycle; create trigger create or replace trigger tr_advert before insert on jcms_advert for each rowbegin select seq_advert.nextval into: new. id from dual; end; insert record insert into jcms_advert (siteid, name, updatetime) values (1, 'header ad', sysdate); query record select * from jcms_advert;