Re: pl/sql help: LAST_ROW_ID question...

LAST_ROW_ID to identify the last row processed in  multi-row update.
So that would mean rowid is referring to tbl1, right? tbl1 is the table updated, not tbl2.
Could you please be more specific with respect to 'the subselect fails'

Hth,

Sybrand Bakker, Oracle DBA

<flaggedatbest_at_yahoo.com> wrote in message news:8p877l$j97$1_at_nnrp1.deja.com...
>
>
> Excuse my ignorance, but I'm no pl/sql guru!
>
> I'm trying to use LAST_ROW_ID to identify the last row processed in
> multi-row update.
>
> ie. update tbl1 set(a, b c) = (select a, b,c from tbl2);
> (the subselect fails and I want to identify the row)
>
> What is this id, anyway? How does it translate into a row in tbl2.
>
> All of the documentation that I've found on the subject simply says
> that it's a "row id".
>
> thanks in advance,
>
> -Dan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 07 2000 - 16:52:52 CDT