Sequences: where do 'unused' numbers go in case of rollback
From: Edward W. Vergragt <E.W.Vergragt_at_inter.nl.net>
Date: 1995/10/01
Message-ID: <DFq8JC.BFM_at_inter.NL.net>#1/1
Date: 1995/10/01
Message-ID: <DFq8JC.BFM_at_inter.NL.net>#1/1
The Oracle-sequence-numeber can be accessed via :
Select <sequence_name>.nextval
from dual
Any help (or pointers to the right place in the Oracle-doc) is appreciated...
SWM Automatisering
Edward W. Vergragt
vergragt_at_inter.NL.net
programmatuur voor handel in bulk-goederen (commodities), gebaseerd op het Oracle RDBMS software for commodity-traders, trafficers, Oracle-based Received on Sun Oct 01 1995 - 00:00:00 CET