Re: HOW TO SET SEQUENCE VALUE
From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 29 Mar 2012 14:26:34 +0100
Message-ID: <CAPCNhx2sYkG+T3e-A8+BCbO=6YgOX-88_S2A05yJFabcPodnpw_at_mail.gmail.com>
Unfortunately Sequence numbers along with a couple of other 'features' often appear
in 'My First Oracle System' I was thinking of varchar2 - If you want to see your data again don't put it in there! :-) I don't really see why the manual doesn't say next to sequences numbers that contiguous numbers cannot be guaranteed to prevent this error. I don't think this would do Oracle's Reputation any harm, in fact warning of 'silly' assumptions would be a good thing. (I'm sure it says it somewhere but it should be prominent.)
Date: Thu, 29 Mar 2012 14:26:34 +0100
Message-ID: <CAPCNhx2sYkG+T3e-A8+BCbO=6YgOX-88_S2A05yJFabcPodnpw_at_mail.gmail.com>
Unfortunately Sequence numbers along with a couple of other 'features' often appear
in 'My First Oracle System' I was thinking of varchar2 - If you want to see your data again don't put it in there! :-) I don't really see why the manual doesn't say next to sequences numbers that contiguous numbers cannot be guaranteed to prevent this error. I don't think this would do Oracle's Reputation any harm, in fact warning of 'silly' assumptions would be a good thing. (I'm sure it says it somewhere but it should be prominent.)
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 08:26:34 CDT