RE: Rownum

From: John Blake <jblake_at_arrow.com>
Date: Wed, 19 Mar 2003 08:43:26 -0500
Message-Id: <24715.322357@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0022_01C2EDF3.9C775FA0 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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_0022_01C2EDF3.9C775FA0
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.00.3013.2600" name=3DGENERATOR></HEAD>

<BODY=20

style=3D"BACKGROUND-COLOR: #ffffff; BACKGROUND-IMAGE: =
url(http://skins.hotbar.com/skins/mailskins/st/093002/093002us_sunset.jpg=
); BACKGROUND-POSITION: right bottom; BACKGROUND-REPEAT: repeat-x; =
COLOR: #220000; FONT-FAMILY: Verdana; FONT-SIZE: 10pt; FONT-STYLE: =
normal; FONT-WEIGHT: normal; MARGIN: 3px 5px 90px 6px"=20
hmark=3D"hotbar_element" ?bgcolor=3D"#ffffff" hbtype=3D"st" =
stationery_tag_mark>


<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.&nbsp; =


</SPAN></DIV>

<DIV><SPAN class=3D90184113-19032003></SPAN>&nbsp;</DIV>

<DIV>&nbsp;</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>&nbsp;</DIV>
  <DIV><SPAN class=3D937424009-19032003>&nbsp;&nbsp;&nbsp;&nbsp; I =
wanted to know=20
  the concept of Rownum.. Is it similar to Row Id ?</SPAN></DIV>
  <DIV><SPAN class=3D937424009-19032003></SPAN>&nbsp;</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 color=3Dgray noShade SIZE=3D1 width=3D"100%">
  <A=20
  =
href=3D"http://promos.hotbar.com/promos/promodll.dll?RunPromo&amp;El=3Dho=
tbar%5felement%3bst%3b&amp;SG=3D&amp;RAND=3D13042"><IMG=20
  alt=3D"Upgrade Your Email - Click here!" border=3D0=20
  =
src=3D'http://promos.hotbar.com/promos/promodll.dll?GetPromo&amp;El=3Dhot=
bar%5felement%3bst%3b&amp;SG=3D&amp;RAND=3D13042"'=20
  title=3D"" NOSEND=3D"1"></A> </DIV></BLOCKQUOTE></BODY></HTML>

Received on Wed Mar 19 2003 - 07:43:26 CST