George, I agree with you. We also use sysdate at time of insert for a
datetime stamp, and we frequently have several rows with the same datetime
stamp.
At 09:40 AM 6/6/00 -0800, you wrote:
>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: <dgoulet_at_vicr.com> [mailto:dgoulet_at_vicr.com]
> > Sent: Tuesday, June 06, 2000 5:06 PM
> > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>]; George Brennan_at_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_at_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: <dgoulet_at_vicr.com> [mailto:dgoulet_at_vicr.com]
> > > Sent: Tuesday, June 06, 2000 4:10 PM
> > > To: smtp_at_inl001@servers["Multiple recipients of list ORACLE-L"
> > > <ORACLE-L_at_fatcity.com>]
> > > 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" <rajendra.jamadagni_at_espn.com>
> > > Date: 6/6/00 5:50 AM
> > >
> > > Create and use a sequence to number your records.
> > >
> > > HTH
> > > Raj
> > > --
> > > Author: Jamadagni, Rajendra
> > > INET: rajendra.jamadagni_at_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_at_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_at_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_at_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_at_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_at_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_at_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_at_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
Received on Wed Jun 07 2000 - 11:39:14 CDT
