Hemant K Chitale wrote:
>
> So, let's start another thread.
>
> How many of you have actually seen Sequences implemented in the manner I
> described
> and Mladen demonstrated below ?
>
> Hemant
>
What I have seen used are non-cycling sequences which are forced to
cycle - the idea is to restart the numbering from 1 everyday. So,
everyday at midnight the sequences are ALTERed so that their maximum is
today's maximum, and they are forced to return to 1 - before making them
NOCYCLE again. The big advantage on dropping and recreating them is that
existing privileges stay in place and you don't have to GRANT SELECT to
everybody ...
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroult
INET: sfaroult_at_oriole.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sun Nov 09 2003 - 09:44:25 CST
