Message-Id: <24715.322344@fatcity.com> From: ISI/BDD/HAOUHACH Date: Wed, 19 Mar 2003 12:34:35 -0000 Subject: RE: Rownum 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@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 Upgrade Your Email - Click here!=20 ------_=_NextPart_001_01C2EE13.E6128D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
just do
select rownum, col1,col2,.... = from=20 table1
 
-----Message d'origine-----
De : Santosh = Varma=20 [mailto:vsantosh@psi.soft.net]
Envoy=E9 : mercredi 19 = mars 2003=20 09:44
=C0 : Multiple recipients of list=20 ORACLE-L
Objet : Rownum

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