Re: Autoincrement in Oracle 8.1.7

Dave wrote:

> Hello.
>
> I am fairly new to Oracle, can anyone tell me if there is a way to
> create a column (primary key) that the database itself will fill in
> automatically with a sequential number ?
>
> Thanks in advance

Create a sequence. Then use it in a before-insert trigger.

Oracle, and I am so grateful, does not have autoinsert.

Daniel Morgan Received on Fri Apr 26 2002 - 14:50:48 CDT