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

> select * from emp where rowid = 'AAACqqAACAAAAEHAAM';

cool. I can use "where rowid = ..." in a where clause.

> I am curious about exactly HOW you use the function LAST_ROW_ID ?

I haven't tried it yet but my docs say:

    After a FETCH_ROWS or an EXECUTE_AND_FETCH     v_row_id = DBMS_SQL.LAST_ROW_ID();

thanks,

-Dan

In article <8pamdc$g2u$1_at_nnrp1.deja.com>,   rock_cogar_at_my-deja.com wrote:
>
> > Yes. So how do I take a "row id" and determine the actual row?
>
> ROWID is just the unique key that Oracle uses to identify rows.
>
> example:
>
> select rowid from emp where ename = 'FORD';
>
> ROWID
> ==================
> AAACqqAACAAAAEHAAM
>
> So, it can be used in reverse like:
>
> select * from emp where rowid = 'AAACqqAACAAAAEHAAM';
>
> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
> ===================================================
> 7902 FORD ANALYST 7566 12/03/1981 00:00:00 3000 20
>
> I am curious about exactly HOW you use the function LAST_ROW_ID ?
>
> Rock.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 08 2000 - 08:19:05 CDT