Determine Physical Row Number 1

[Michael42]

Hello,

I know you can user rownum to determine the row number returned of a row in a SQL call.

How can you determine the actual physical row number of a record\row in a table?

Thanks,

Michael42

 

[SantaMufasa]

Michael,

Using ROWID can be very useful in certain queries, so it is good to know how to access it:

select rowid,last_name from s_emp;

ROWID              LAST_NAME
------------------ ------------
AAAEmGAAEAAAAE6AAA Velasquez
AAAEmGAAEAAAAE6AAB Ngao
AAAEmGAAEAAAAE6AAC Nagayama
AAAEmGAAEAAAAE6AAD Quick-To-See
AAAEmGAAEAAAAE6AAE Ropeburn
AAAEmGAAEAAAAE6AAF Urguhart

Let us know if this does what you wanted.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Michael42]

ROWID it is.

Thanks Santa!

Michael42