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;