create sequence sequence_name;  -- check docs for various parameters on this command
 
create or replace trigger trigger_name
  before insert on table_name
  for each row
begin
  if :new.pk_column is null then
    select sequence_name.nextval
      into :new.pk_column
      from dual;
  end if;
end;
/