Message-Id: <10520.107914@fatcity.com> From: George.Brennan@warnermusic.com Date: Tue, 6 Jun 2000 16:18:58 GMT Subject: Re:RE: Equivalent of Access autonumber Hmmm, I appreciate that you can use dbms_utility.get_time but that needs a binary_integer data type. Unless I'm missed something a date/time is only accurate to 1 second - 'hh:mi:ss', and I have missed things before!. Regardless, this still assumes that Oracle can't insert more than 1 record with the same timestamp. I still can't see a 100 inserts/sec as a max limit for Oracle. Hence IMHO, the suggestion to use a sequence. regards George. > -----Original Message----- > From: [mailto:dgoulet@vicr.com] > Sent: Tuesday, June 06, 2000 5:06 PM > To: smtp@inl001@servers["Multiple recipients of list ORACLE-L" > ]; George Brennan@IT@WMINTL19 > Subject: Re:RE: Re:RE: Equivalent of Access autonumber > > > George, > > We insert the date/time to the max accuracy that Oracle > allows (100th of a > second). Therefore retrieving the data in sorted order of > when it was created > is totally possible, unless as I said you truncate the date > during insert in > which case the time is always midnight. BTW, you can just > use sysdate during > the insert to get the exact time of creation. > > ____________________Reply Separator____________________ > Subject: RE: Re:RE: Equivalent of Access autonumber > Author: George.Brennan@warnermusic.com > Date: 6/6/00 8:50 AM > > > 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). > > > > > > > -- > Author: > INET: George.Brennan@warnermusic.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