Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Guaranteed Order With a Sequence / Trigger
John,
No matter what you do, you cannot guarantee 'NO GAPS'. If at any time you delete a row, you have a gap. If at any time you add rows within a transaction and then rollback, you have a hole. In short even prayer won't help
Dov Trietsch Received on Sat Oct 30 1999 - 10:59:31 CDT