To create a self-increasing ID field in an Oracle database _oracle

The steps to use the self-increasing ID field in Oracle are cumbersome, as summarized below:

--Create a table

CREATE TABLE ADVICE
(
ID INT not NULL,
ACTIVE INT DEFAULT 1 is not NULL,
TYPE int. NOT NULL, 
MSG VARCHAR2 ( ) not NULL,
ADVICE VARCHAR2 (4000) is not NULL,
PRIMARY KEY (ID),
CONSTRAINT Advice_uni UNIQUE (type,msg)
) Tablespace MYDB;

--Create your own ID, Name: Table name _ Field name _seq
CREATE SEQUENCE advice_id_seq minvalue 1 nomaxvalue INCREMENT by 1 START with 1 nocache;
  
   --creates a trigger for the INSERT operation without writing a nextval in the SQL statement, named table name _INS_TRG
Create OR REPLACE TRIGGER ADVICE_INS_TRG before INSERT on ADVICE for each ROW, New.id is NULL,
BEGIN
SELECT advice_id_seq. Nextval INTO:NEW.ID from DUAL;
End;