Re: Clarification of 'Sequences'

From: <paul.baumgartel_at_aya.yale.edu>
Date: 1998/09/30
Message-ID: <6utqf4$tqa$1@nnrp1.dejanews.com>#1/1

In article <6ute2i$2a7$1_at_zeke.ebtech.net>, "steve hendrikse" <shend_at_sar-net.com> wrote: [snip]

> now, i conclude that if both MSSQL and PostgreSQL can do this (as shown
> above) there has to be a 'graceful' way to get Oracle to do it also.

Oracle requires that you either specify "sequence.nextval" explicitly as a column value in an INSERT statement, or that you populate the column with "sequence.nextval" in an insert trigger.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Sep 30 1998 - 00:00:00 CDT