Message-Id: <10520.107858@fatcity.com>
From: "Marin Dimitrov" <marin@sirma.bg>
Date: Tue, 6 Jun 2000 16:24:37 +0300
Subject: Re: Equivalent of Access autonumber

> Can Oracle have a autonumber like in Access?

create a sequence and a "before insert" trigger for that table that will
insert nextval from the sequence into the desired column

hope this helps,

    Marin

---------

"When brought to meaning, all importance becomes small, as in death,
all life seems nothing. Knowing is destroyed by thinking,
distilled into knowledge"

                                                 William Wharton, "Birdy"