Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: questions to ROWID
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.