Re: Creating IDs subsequently

"Mark D Powell" <Mark.Powell_at_eds.com> schrieb im Newsbeitrag news:2687bb95.0307210545.24641c9b_at_posting.google.com...
> "Gerd Forster" <gf_at_nospam.at> wrote in message
news:<bfgek8$e117p$1_at_ID-119152.news.uni-berlin.de>...
> > Hello everybody,
> >
> > I have a table with timestamp and other information.
> > Recently I added a numeric ID column.
> >
> > I want to fill in IDs in CHRONOLOGIC ORDER.
> >
> > Is this possible by an update statement, or do I have to write
> > a procedure?
> >
> > Thanks in advance
> > Gerd Forster
>
> Gerd, this is from the version 9.2 DBA Admin manual, "Sequences are
> database objects from which multiple users can generate unique
> integers." There is a chapter on managing them in the Admin manual
> and it refer readers to the Concepts manual for more information.
> Perhaps a sequence generator (create sequence command in SQL manual)
> will fit your bill.
>
> If you want true CHRONOLOGIC ORDER what was wrong with using the
> timestamp as the key?
>
> HTH -- Mark D Powell --

Hi Mark,

I'm sorry, I did not mention that I am Using Oracle 8. And there is only the DATE type and SYSDATE, which is not able to generate unique keys.
So "chronolgic order" is only an approximation.

Thank you very much for your posting!
Gerd Forster Received on Tue Jul 22 2003 - 03:55:53 CDT