Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Any way to get seq.currval without using nextval?

Re: Any way to get seq.currval without using nextval?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Tue, 09 Oct 2001 09:55:46 GMT
Message-ID: <3bc2c90e.1628093@news> 





On Mon, 8 Oct 2001 11:37:04 -0500, "Kevin Brand"
<kevin.brandx_at_tel.gte.com> wrote:



>

>Would this not be a little skewed if  SEQUENCE_CACHE_ENTRIES is non-zero?

>




Yes. But not by much.  If all that's needed is an approximate value,
then it's kosher.


I think the caching can still be turned off?  (haven't checked that in
AGES!!!)



Cheers


Nuno Souto


nsouto_at_optushome.com.au.nospam
Received on Tue Oct 09 2001 - 04:55:46 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US