Re: Bypassing Rowid?

Aha,

    The plot thickens!

    Oracle has both ROWID and ROWNUM. An Oracle ROWID is (conceptually) Oracle's internal primary key that is used to access a row in a table. An Oracle ROWNUM corresponds to the row's sequence in the response to a query.

    If you manage to change a rowid you will, as a byproduct, corrupt your database -- not a good idea.

    If you take a query and add ROWNUM to the selected columns you will observe that ROWNUM increases by one with each succeeding row that is returned by the query. Now take the same query and add a condition that will reduce or increase the number of rows returned and you will see that the ROWNUMs will differ from query to query.

    regards

Jerry Gitomer

Jerra wrote in message <373EB757.A0C1E988_at_consilia.com>...
>I mixed RowId with Autonumber/Identity (MS DB's) (-;
>All the best!
>/Jerra
>
>Jerra wrote:
>
>> I thought that by loading data with sql*loader you bypassed all triggers
>> and rowid etc, just stuffing the database with bulk-data.
>> Apparently it's not. So how do I do? I want to insert data in RowId
>> columns . Oracle does not like that naturally, but there must be a way
>> to do it.
>>
>> Any help greatly appreciated!
>> Regards
>> Jerra
>
Received on Mon May 17 1999 - 12:27:19 CDT