Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: questions to ROWID

Re: questions to ROWID

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 13 Dec 2002 12:18:36 +0100
Message-ID: <MPG.1863e075118cf8579896dc@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.

Received on Fri Dec 13 2002 - 05:18:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US