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;