Oracle8i and sequence tables

From: <sooty70_at_my-deja.com>
Date: Tue, 24 Oct 2000 15:18:49 GMT
Message-ID: <8t498e$80c$1@nnrp1.deja.com>

Hi folks,

Let me start by saying that I don't currently have access to an Oracle8i database so I can't test this on my own so I'm not being lazy. :-)

If I get sequence.nextval from a given sequence and then start using currval for X amount of inserts/updates afterwards, if someone else performs a sequence.nextval in another session will my currval change? In short, is the sequence.currval session specific?

Thanks, Martin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 10:18:49 CDT