Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_rowid.rowid_row_number---clarification

dbms_rowid.rowid_row_number---clarification

From: Venugopal V V S <venug_at_cse.iitb.ernet.in>
Date: Fri, 2 Jun 2000 11:40:58 +0530 (IST)
Message-Id: <10515.107511@fatcity.com>


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

4 rows selected.

Why the first column(dbms_rowid......) starts from 0 and second col.(rownum) from 1?

TIA.
Regards..



Venu Gopal VVS.
Software Engineer.
Project SMARS.
Dept. of Comp. Sc. & Engg.
IIT Bombay, Powai
Mumbai, INDIA, 4000076
Lab.Phone.5782545 X 8913
Direct Ph. 5768703
Tansa Room# 331 Ph.5612                  
		URL         http://venug.8m.com/index.htm
                Resume      http://venug.8m.com/resume.htm
_____________________________________________________________________________
Received on Fri Jun 02 2000 - 01:10:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US