Re: How to create "auto-increment" field WITHOUT a sequence object?

On Jun 30, 2011, at 2:40 PM, Dmitry Koterov wrote:

> Hello.
>
> I need to create an auto-increment field on a table WITHOUT using sequences:

This problem pops up a lot for invoice sequence numbers for the tax office and related cases. (Search for "gapless
sequence".) 

Since the numbers are really only needed for an external system (as you mention), then it may make sense to generate
thegapless IDs when necessary and map the generated IDs to the rows later. The drawback is that some rows in the table
willnot have the gapless ID until the batch job is run, but all rows will still be addressable by the real sequence ID. 

Cheers,
M