To create a self-increment ID field in an Oracle database

CREATE TABLEADVICE (IDINT  not NULL, ACTIVEINT DEFAULT 1  not NULL, TYPEINT  not NULL, MSGVARCHAR2( +) not NULL, ADVICEVARCHAR2(4000) not NULL,PRIMARY KEY(ID),CONSTRAINTAdvice_uniUNIQUE(type,msg)) Tablespace MYDB; --Create a self-increment ID named: Table name _ Field name _seqCREATESEQUENCE Advice_id_seq MINVALUE1Nomaxvalue INCREMENT by 1START with 1NOCACHE; --create a trigger for the insert operation without having to write nextval in the SQL statement, name is table name _INS_TRGCREATE OR REPLACE TRIGGERADVICE_INS_TRG beforeINSERT  onADVICE forEach ROW when(new.id is NULL)BEGINSELECTAdvice_id_seq. Nextval into: new.id fromDUAL;END;

To create a self-increment ID field in an Oracle database