RAFT Sequence

create table counselor( COUNSELOR_ID int Primary Key, FIRST_NAME varchar(20), LAST_NAME varchar(20), PHONE varchar(14) ); insert into counselor values(10,'Quinn','Fowler','(508) 244-1416'); insert into counselor values(11,'Elizabeth','Baker','(508) 243-1789'); insert into counselor values(12,'Darrold','Cooper',NULL); select * from counselor; create sequence ObjectID start with 100 increment by 1; select objectid.nextval from dual; CREATE OR REPLACE TRIGGER counselor_PK BEFORE INSERT ON counselor FOR EACH ROW begin select ObjectID.nextval into :new.counselor_id from dual; end; / insert into counselor values(null,'Leslie','Wright','(508) 244-5586'); insert into counselor values(1000,'Abigail','Smith','(508) 244-6931'); insert into counselor (first_name, last_name, phone) values('James','Sawyer','(508) 247-7631');