Skip to Content

How to generate a huge continuously bigint sequence?

Dear All,

Now I need to generate a huge continuously bigint sequence. Before I used number(), but it can only support integer not bigint, and I tried identity column but soon I found that identity gap issue hits so often. Then I tried rowid() on temp table, but there's also the gap on rowid() sorting so it can't be continuously.

Would anyone please share your idea on how to generate this bigint sequence? Thanks in advance for any help.

Regards

Eisen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers