Creating a new table with autoincrement column on Oracle database

create_user_accounts_table.sql

CREATE TABLE USER_ACCOUNTS (
   ID          NUMBER(10)      NOT NULL,
   EMAIL       VARCHAR(30)      NOT NULL,
   PASSWORD    VARCHAR(100)    NOT NULL
);

ALTER TABLE USER_ACCOUNTS ADD (
   CONSTRAINT user_acc_pk PRIMARY KEY (ID)
);

CREATE SEQUENCE user_acc_seq START WITH 1;

CREATE OR REPLACE TRIGGER user_acc_before_insert_trigger
BEFORE INSERT ON USER_ACCOUNTS
FOR EACH ROW

BEGIN
   SELECT user_acc_seq.NEXTVAL
   INTO :new.id
   FROM dual;
END;