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.