-----Original Message-----
From: Faranak Z. [mailto:faranak@egeporcan.com.tr]
Sent: Thursday, August 13, 1998 7:57 AM
To: akaplan@interaccess.com
Subject: HOW TO RETRIVE ROWID
Dear Ari,
I'm a Computer Engineer. I'm new at Oracle and Developer/2000. I have a
master/detail block in developer/2000 1.5. I want to use ROWID of any
record in the master block and update the related detail data in the detail
block (I want to use that ROWID as a unique number in my detail table).
My problem is that I don't know how to retrive the ROWID of any specific
record.
Any help from you will be highly appreciated.
Best regards,
PS: By the way I found your web page very useful....
Faranak Z.
-----Reply--------------
Farank,
If you have a table like the following:
SERVICE
NAME VARCHAR2(30),
STATUS VARCHAR2(30)
To get the ROWID with each row, type:
SELECT ROWID, NAME, STATUS FROM SERVICE;
The result will include the ROWID, which will look like:
ROWID NAME STATUS
_____________________ _______________ ________
AAAAkmAAFAAADm/AAK PIN Service Object 10100
AAAAkmAAFAAADnAAAA PIN Service Object 10100
AAAAkmAAFAAADnAAAB PIN Service Object 10100
In Oracle7, the ROWIDs look different. If you have Oracle8, you can look into the DBMS_ROWID package to convert to Oracle7 format.
Best of luck,
-Ari Kaplan
www.arikaplan.com
Back to Ari Kaplan's Home Page