Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> dbms_rowid.rowid_row_number---clarification
hi *,
the query as follows....
select dbms_rowid.rowid_row_number(rowid),rownum from scott.emp;
dbms_rowid.rowid_row_number(rowid) rownum ---------------------------------- ------ 0 1 1 2 2 3 3 4
Why the first column(dbms_rowid......) starts from 0 and second col.(rownum) from 1?
TIA.
Regards..
URL http://venug.8m.com/index.htm Resume http://venug.8m.com/resume.htm _____________________________________________________________________________Received on Fri Jun 02 2000 - 01:10:58 CDT