Re: Sequences (default max value???)

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Mon, 16 Nov 98 23:35:00 +0200
Message-ID: <AC4g9KsK42@protasov.kiev.ua>

Hi,

Default maxvalue is nomaxvalue. It is 1e27 for ascending sequences and -1 for descending sequences according to SQL Reference.

According to my experience nomaxvalue is 999...999 (27 digits). So it is (1e27)-1.

Andrew Protasov

> I've hunted through the documentation I have on sequences yet have not
> found a reference to the *default* maxvalue.
>
> I've instantiated a number of sequences, but never specified a
> maxvalue.
>
> Any idea if this will haunt me?
> --
> Joe Brown - Programmer
> joebrown_at_leading.net - DBA
> joe@.hopi.dtcc.edu - Network Admin
> http://users.leading.net/~joebrown Have a Great day!!!
Received on Mon Nov 16 1998 - 15:35:00 CST