Automatic sequential record numbering?

From: Jon S <strauss_at_wpb.nuwc.navy.mil>
Date: 2000/08/12
Message-ID: <2000Aug12.151300.327@npt.nuwc.navy.mil>#1/1

Hi,

I'm new to Oracle and I was wondering what the best method is for automatically generating a new sequential number for each record inserted in a table. For instance, I have a table that holds problem reports. Each report needs a unique identifier and should be sequential (i.e. the first one would be report #1, the second would be report #2, etc.) Also, I would like the numbers to not have any gaps in them so that I can keep track of each problem report. I'm currently using a sequence to accomplish this, but I was wondering if there was a better method.

This application runs on WinNT 4.0 server as an IIS app with Oracle 8i.

Thanks,
Jon Received on Sat Aug 12 2000 - 00:00:00 CDT