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: <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).
Received on Tue Jun 06 2000 - 10:22:25 CDT