Re: "autonumber" field - how to?

Conner-
  THANK YOU! Bill

Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message news:38390555.73ED_at_yahoo.com...
> Bill Cohagan wrote:
> >
> > I'm an Oracle newbie, having worked previously in Access and SQL7. In
both
> > of these systems I am able to easily create an "autonumber" field; i.e.,
a

   <snip>...
> > TIA,
> > Bill
>
> replace with:
>
> select seq_abc.nextval
> into :new.field
> from dual;
>
> and SHOW ERRORS will work, you just need a little more info - you can
> use:
>
> show errors trigger trigger_name
>
> (and similarly with procs/funcs/packages)
>
> HTH
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Mon Nov 22 1999 - 16:08:47 CST