Re: Rowid, whatfor?

From: Spencer <spencerp_at_swbell.net>
Date: Sat, 9 Jun 2001 14:44:58 -0500
Message-ID: <m%uU6.107$Gs4.51544@nnrp3.sbc.net>

using a 'for update' cursor does allow you to specify an update for the 'current' row, and that works fine. but what if you fetch several rows, and you need to update a previously fetched row, that is, not the current one. in that case, using ROWID gives you the fastest possible access to the row.

HTH "T.Ruschival" <t.ruschival_at_vivid-md.de> wrote in message news:B748157D.3B00%t.ruschival_at_vivid-md.de...
> Hello DB-Developers
>
> Well I´m a greenhorn to Oracle PL/SQL. I read a lot but I don´t understand
> some issues. For example the Rowid.
> To obtain the Rowid I have to state a Select-Query, then I can find out
the
> Ids of the Rows returned by that Statement. At this Moment I know the
> selected Rows already an I can refer to it for update by cursor.current .
> What is the Rowid good for? i don´t understand why everybody writes about
> this in every book?
> Please give me a hint about what I can do with this suspicios ID.
>
> Thanks Thomas
>
>
Received on Sat Jun 09 2001 - 14:44:58 CDT