I know this should be simple but I'm lost.
I want to create a trigger that will fire before insert on a table to get the next sequence value for the primarykey of the table:
create or replace trigger wells_ins_row
before insert on Wells
for each row
begin
WellID := wellsid_seq.nextval;
end;
/
The table is name Wells and the column WellID is the PK for the table. There is a wellsid_seq created to get the sequence number from.