When using the NO CACHE option when creating a sequence is it always guaranteed that the sequence will have no jumps or gaps? I know this will impact performance but I have a requirement where by values must be sequential with no gaps and I was wondering
if I could use the sequences.
Go to the complete details ...