From: rajXesh@hotmail.com (RK) Newsgroups: comp.databases.oracle Subject: Re: Where to publish an article? Date: 11 Nov 2002 07:59:04 -0800 Organization: http://groups.google.com/ Lines: 27 Message-ID: <548b9514.0211110759.7ec3c941@posting.google.com> References: NNTP-Posting-Host: 12.33.164.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037030345 444 127.0.0.1 (11 Nov 2002 15:59:05 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Nov 2002 15:59:05 GMT Alexander.Kuznetsov@marshmc.com (Alexander Kuznetsov) wrote in message news:... > Hi all, > I have invented a simple and efficient method of generating unique > numbers in the middle tier. It's published on IBM's Web site: > www7b.boulder.ibm.com/dmdd/library/techarticle/0209kuznetsov/0209kuznetsov.html > the method is described in Chapter 2. > I'm getting very encouraging feedback so far. > I'd like to expose the idea to Oracle developers, but I wasn't able to > find a magazine and/or Web siten aimed at designers and developers, > something similar to DB2 Developers Domain. > > I'd be thankful for any suggestions. > Alexander. Perhaps I did not quite understand, but how is your process more efficient than the Oracle Sequence Numbers. Also instead of defining version_id as number, define it as date or timestamp and set it to sysdate or systimestamp and using that in the where clause should eleminate the 'nasty problem' -- rajXesh "All you need in this life is ignorance and confidence, and then success is sure." -- Mark Twain (1835 - 1910)