Re: questions to ROWID

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Fri, 13 Dec 2002 11:58:01 -0000
Message-ID: <dXjK9.35011$zX3.78284@news.indigo.ie>

The rowid can change ! - note he hasn't stated what kind of table.

Although you are correct - it does not always return in order. A sequence on insert is handy too.

"tojo" <Tojo_at_hotmail.com> wrote in message news:MPG.1863e075118cf8579896dc_at_news.t-online.de...
> In article <atcevn$12g5da$1_at_ID-70985.news.dfncis.de>,
> romazanov.andrei_at_gfos.de says...
> > Hi,
> >
> > The following two questions to ROWID:
> >
> > 1. can UPDATE change the ROWID?
> > 2. can I assume that
> >
> > SELECT * FROM TAB ORDER BY ROWID
> >
> > always returns the records in the order of the production?
> >
> 1. No. Only exporting/importing can change rowid's. Otherwise they're
> constant.
> 2. No.
>
> If you need records in order of production, add an extra date column
> like PROD_DATE.
>
> -- Tom
>
Received on Fri Dec 13 2002 - 05:58:01 CST