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

From: <rock_cogar_at_my-deja.com>
Date: Fri, 08 Sep 2000 12:34:52 GMT
Message-ID: <8pamdc$g2u$1@nnrp1.deja.com>

> 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. Received on Fri Sep 08 2000 - 07:34:52 CDT