Message-Id: <10520.107892@fatcity.com> From: George.Brennan@warnermusic.com Date: Tue, 6 Jun 2000 15:22:25 GMT Subject: RE: Re:RE: Equivalent of Access autonumber Using a date column will only work if you specify that updates are >1 second apart. George > -----Original Message----- > From: [mailto:dgoulet@vicr.com] > Sent: Tuesday, June 06, 2000 4:10 PM > To: smtp@inl001@servers["Multiple recipients of list ORACLE-L" > ] > Subject: Re:RE: Equivalent of Access autonumber > > > I cannot see where a date field will not work, unless your > intentionally > truncating the date during insert. We process 100,000 data > records per day from > automatic test equipment into our database each day. At > present it's over 100 > Million rows & the date/time stamp works just fine. > > ____________________Reply Separator____________________ > Author: "Jamadagni; Rajendra" > Date: 6/6/00 5:50 AM > > Create and use a sequence to number your records. > > HTH > Raj > -- > Author: Jamadagni, Rajendra > INET: rajendra.jamadagni@espn.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Author: > INET: dgoulet@vicr.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).