Re: Default sequence number

From: Imtiaz Ahmed <imtiaz_at_qatar.net.qa>
Date: 1996/10/29
Message-ID: <01bbc598$00e30740$352185c2_at_r2d2>#1/1


yes I suppose thats the compromise you have to make. By the Way, maybe using a view can solve this problem as well ( Do let me know after trying).

The reason why ORACLE does not use NEXTVAL as default is may be because the sequence which NEXTVAL refers can be dropped any time and moreover the sequence can be altered by user, which in turn can generate an illegal value for your column.

Imtiaz Ahmed.
imtiaz_at_qatar.net.qa Received on Tue Oct 29 1996 - 00:00:00 CET

Original text of this message