SELECT  ROWID,NAME FROM SM_EMP;

select ROWID,ename FROM emp ;

--用ROWID做WHERE條件,最快的定位方法！
select ROWID,ename FROM emp where ROWID ='AAAGDaAABAAAIRKAAA';

--顯示記錄的物理位置為更可讀的方法
SELECT ROWID, 
       SUBSTR(ROWID,1,6) "OBJECT", 
       SUBSTR(ROWID,7,3) "FIL", 
       SUBSTR(ROWID,10,6) "BLOCK", 
       SUBSTR(ROWID,16,3) "ROW" 
       FROM emp;