Re: questions to ROWID

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.

Consider partitioned table. If columns updated are part of partition key, row can be moved to another partition. Hence, rowid will be changed.

   Igor Izvekov.

> 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 - 10:13:27 CST