Creating primary key values with trigger

  I think it would be nice if oracle could create primary key values automagically (like 'counter' fields in MS Access). I was thinking about something like this:

create table myTable (

  ID         number(5)   CONSTRAINT pk_myTable PRIMARY KEY,
  field1     char(30),

create sequence seq_myTable ;

create or replace trigger check_myTable
  before insert
  on myTable
  for each row
begin
  :new.ID := seq_myTable.nextval ;
end ;

  This doesn't work because Oracle checks for null values in the ID field before running the trigger.

  This way I have to use a default value (usually 0) in the ID field in the form application (I'm using MS Access, much better than SQL*Forms :) ) so that oracle passes by the not null check and then runs the trigger.

  Any other ideia, comments ?

--
Pedro Pimentel
e-mail: ppf_at_fct.unl.pt
www:    http://ester.fct.unl.pt/pedro1.htm