Re: autoID

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 23 Feb 2000 15:33:36 +0100
Message-ID: <951325967.1354.0.pluto.d4ee154e@news.demon.nl>

Use a sequence for this purpose in combination with a before insert trigger on the table.

Hth,

Sybrand Bakker, Oracle DBA

realtime <na_at_na.ca> wrote in message
news:W%Rs4.42673$632.1799672_at_news1.rdc2.on.home.com...
> I was was wondering if I can create a field that will automatically
generate
> a ID number when data is inserted into the rest of the table is this
> possible
>
>
>
>
Received on Wed Feb 23 2000 - 08:33:36 CST