Skip to Content

How to generate a huge continuously bigint sequence?

Jan 18, 2017 at 12:14 PM


avatar image

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.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers