Re: Alternatives to Sequences?

Can't you just set the default value of the column to foo_sequence.nextval?

"Klaus Born" <KlausBorn_at_caps.de> writes:

> i use a trigger which is a little bit different. insted of
> > > select foo_sequence.nextval
> > > into :new.keycolumn
> > > from dual;
> i would prefer something like this
>
> if new.keycolumn is null then begin
> select foo_sequence.nextval
> into :new.keycolumn
> from dual;
> end

--
greg Received on Tue Oct 05 1999 - 11:54:24 CDT