Oracle ROWID

The Oracle ROWID pseudocolumn returns the address of the row.

Oracle ROWID pseudocolumn example

Select 
rowid, name 
From customers  
Where customer_id=2378;

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

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