Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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