RE: Rownum

From: ISI/BDD/HAOUHACH <lhaouhach_at_avl.sonatrach.dz>
Date: Wed, 19 Mar 2003 12:34:35 -0000
Message-Id: <24715.322344@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2EE13.E6128D40
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

just do=20
select rownum, col1,col2,.... from table1 =20

-----Message d'origine-----
De : Santosh Varma [mailto:vsantosh_at_psi.soft.net] Envoy=E9 : mercredi 19 mars 2003 09:44
=C0 : Multiple recipients of list ORACLE-L Objet : Rownum

Hello list,
=20

I wanted to know the concept of Rownum.. Is it similar to Row Id ? =20
Thanks and Regards,
Santosh=20

_____ =20

=20
<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=3Dhotbar%5fele= ment%3
bst%3b&SG=3D&RAND=3D13042> Upgrade Your Email - Click here!=20

------_=_NextPart_001_01C2EE13.E6128D40
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.3103.1000" name=3DGENERATOR></HEAD> <BODY=20
style=3D"BACKGROUND-COLOR: #ffffff; BACKGROUND-IMAGE: = url(http://skins.hotbar.com/skins/mailskins/st/093002/093002us_sunset.jp= g); 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=3D515433312-19032003>just do </SPAN></DIV> <DIV><SPAN class=3D515433312-19032003>select rownum, col1,col2,.... = from=20
table1</SPAN></DIV>
<DIV><SPAN class=3D515433312-19032003></SPAN> </DIV> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
<DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT=20
  face=3DTahoma>-----Message d'origine-----<BR><B>De :</B> Santosh = Varma=20
  [mailto:vsantosh_at_psi.soft.net]<BR><B>Envoy=E9 :</B> mercredi 19 = mars 2003=20
  09:44<BR><B>=C0 :</B> Multiple recipients of list=20   ORACLE-L<BR><B>Objet :</B> 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 know=20
  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 color=3Dgray noShade SIZE=3D1 width=3D"100%">
<A=20

  =
href=3D"http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=3Dh= otbar%5felement%3bst%3b&SG=3D&RAND=3D13042"><IMG=20   alt=3D"Upgrade Your Email - Click here!" border=3D0=20   =
src=3D'http://promos.hotbar.com/promos/promodll.dll?GetPromo&El=3Dho= tbar%5felement%3bst%3b&SG=3D&RAND=3D13042"'=20   title=3D"" NOSEND=3D"1"></A> </DIV></BLOCKQUOTE></BODY></HTML> Received on Wed Mar 19 2003 - 06:34:35 CST