| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rownum
This is a multi-part message in MIME format.
------=_NextPart_000_00B7_01C2EEC0.C3E4ABB0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Thanks to all who replied to me.
Now it is clear..
santosh
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of John Blake
Sent: Wednesday, March 19, 2003 7:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Rownum
no,
rownum is a sequential number whereas rowid is a pointer to the row of the
table within the database.
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Santosh
Varma
Sent: Wednesday, March 19, 2003 4:44 AM To: Multiple recipients of list ORACLE-L Subject: Rownum
Hello list,
I wanted to know the concept of Rownum.. Is it similar to Row Id ?
Thanks and Regards,
Santosh
------=_NextPart_000_00B7_01C2EEC0.C3E4ABB0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY=20
style=3D"BACKGROUND-POSITION: right bottom; FONT-WEIGHT: normal; =
FONT-SIZE: 10pt; BACKGROUND-IMAGE: =
url(http://skins.hotbar.com/skins/mailskins/st/093002/093002us_sunset.jpg=
); MARGIN: 3px 5px 90px 6px; COLOR: #220000; BACKGROUND-REPEAT: =
repeat-x; FONT-STYLE: normal; FONT-FAMILY: Verdana; BACKGROUND-COLOR: =
#ffffff"=20
stationery_tag_mark hbtype=3D"st" ?bgcolor=3D"#ffffff" =
hmark=3D"hotbar_element">
<DIV><SPAN class=3D615454103-20032003>Thanks to all who replied to=20
me.</SPAN></DIV>
<DIV><SPAN class=3D615454103-20032003>Now it is clear..</SPAN></DIV>
<DIV><SPAN class=3D615454103-20032003>santosh</SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT=20
face=3DTahoma>-----Original Message-----<BR><B>From:</B> =
root_at_fatcity.com=20
[mailto:root_at_fatcity.com]<B>On Behalf Of </B>John =
Blake<BR><B>Sent:</B>=20
Wednesday, March 19, 2003 7:15 PM<BR><B>To:</B> Multiple recipients of =
list=20
ORACLE-L<BR><B>Subject:</B> RE: Rownum<BR><BR></FONT></DIV>
<DIV><SPAN class=3D90184113-19032003>no,</SPAN></DIV>
<DIV><SPAN class=3D90184113-19032003>rownum is a sequential number =
whereas rowid=20
is a pointer to the row of the table within the database. =
</SPAN></DIV>
<DIV><SPAN class=3D90184113-19032003></SPAN> </DIV> <DIV> </DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"><DIV class=3DOutlookMessageHeader><FONT face=3D"Times New = Roman">-----Original=20
Message-----<BR><B>From:</B> root_at_fatcity.com = [mailto:root_at_fatcity.com]<B>On=20
Behalf Of</B> Santosh Varma<BR><B>Sent:</B> Wednesday, March 19, = 2003 4:44=20
AM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
Rownum<BR><BR></DIV></FONT>
<DIV><SPAN class=3D937424009-19032003>Hello list,</SPAN></DIV>
<DIV><SPAN class=3D937424009-19032003></SPAN> </DIV>
<DIV><SPAN class=3D937424009-19032003> I =
wanted to=20
know the concept of Rownum.. Is it similar to Row Id ?</SPAN></DIV>
<DIV><SPAN class=3D937424009-19032003></SPAN> </DIV>
<DIV>
<DIV>
<DIV><FONT face=3DArial>Thanks and Regards,</FONT></DIV>
<DIV><FONT face=3DArial>Santosh </FONT></DIV></DIV></DIV><SPAN=20
id=3Dhotbar_element_used stationery_tag_mark></SPAN>
<DIV id=3Dhotbar_promo><BR>
<HR align=3Dleft width=3D"100%" color=3Dgray noShade SIZE=3D1>
<A=20
title=3D"" alt=3D"Upgrade Your Email - Click here!"=20
=
src=3D'http://promos.hotbar.com/promos/promodll.dll?GetPromo&El=3Dhot=
bar%5felement%3bst%3b&SG=3D&RAND=3D89420"'=20
border=3D0></A> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML> Received on Wed Mar 19 2003 - 21:41:57 CST
 |
 |