Re: Automatic increment filed

From: <rgadd_at_my-dejanews.com>
Date: Thu, 22 Apr 1999 01:31:43 GMT
Message-ID: <7flu5v$92b$1@nnrp1.dejanews.com>

you could write a trigger to max(column) but that could cause full table scans. Another trick is to write a trigger that calls a package that uses a cursor to open and fetch the first row with the column ordered descending.

hope this gives you some ideas.

-Rick

In article <V81T2.2462$xF2.84036_at_weber.videotron.net>, "charlesbergeron" <charlesbergeron_at_videotron.ca> wrote:
> Is it possible to create a table with an automatic increment field without
> using a sequence ?
>
> If there is a way, please show me the path! ;-)
>
> Reply by email will be appreciated
> thanks
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 21 1999 - 20:31:43 CDT