Oracle 의 rowid 구현하기

USE Pubs

go

SELECT (SELECT COUNT(*) FROM authors e2 WHERE e2.au_id <= e.au_id)

 AS rownumber
, au_id, au_lname
FROM authors e ORDER BY au_id