Re: Bypassing Rowid?

I think Jerra wants Rownum as opposed to RowID. Going back to the original question with SQL*Loader, you couldn't insert into rownum anyway. Only can select it and use it to narrow down return results.

e.g

select rownum, empno, ename
from emp
where rownum < 10;

M

Jerry Gitomer wrote in message <7hpjde$gge$2_at_autumn.news.rcn.net>...
>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 Tue May 18 1999 - 03:30:26 CDT