oracle中创建Sequence和Trigger的SQL语句

//建Sequence

create sequence STUDENT_S
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;

//建表
CREATE TABLE STUDENT
(
?? ID INTEGER,
?? "NAME" VARCHAR2(20),
?? ADDRESS VARCHAR2(40),
?? AGE INTEGER
)

//建Trigger
CREATE OR REPLACE TRIGGER INSERTSTUDENTID
BEFORE INSERT ON STUDENT
FOR EACH ROW
BEGIN
??? SELECT STUDENT_S.NEXTVAL INTO :NEW.ID FROM DUAL;
END;