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"