Oracle Tutorial

Rowid Examples

Example 1

Select rowid, name
From customers
Where customer_id=2378;

Example 2

Select customer_id, name, email
From customers
Where rowid = 1000;



Example 3

Declare
v_Customer_Id NUMBER;
v_Rowid ROWID;
Begin
PL/SQL query
End;