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: <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
Received on Tue Jun 06 2000 - 11:18:58 CDT