Re: questions to ROWID

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sat, 14 Dec 2002 00:17:03 +1100
Message-ID: <3df9e0b1$0$12761$afc38c87@news.optusnet.com.au>

Fri, 13 Dec 2002 12:06:50 +0100, Andrei Romazanov said (and I quote):

> The following two questions to ROWID:
>
> 1. can UPDATE change the ROWID?

Not directly. Ie, you cannot say
UPDATE <tname> set ROWID=<value>
WHERE ROWID=<another value>;

> 2. can I assume that
>
> SELECT * FROM TAB ORDER BY ROWID
>
> always returns the records in the order of the production?

No. Not at all.

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Fri Dec 13 2002 - 07:17:03 CST