Darrell Landrum,���ã�
thanx for your explaination.
I wonder :whether i can judge the select return.
I find the rowNUM is not 0, is right?
======= 2003-03-19 05:03:00 �������������=======
>Santosh,
>
>Good question. Actually these 2 are not related.
>Rowid is an actual attribute assigned to each row of a table and is unique.
>Rownum is logically assigned to rows returned in a query (nothing to do with the
>table). It is assigned sequentially as rows are returned (meaning if you can't have
>a rownum 2 until you've gotten a rownum 1).
>
>Ex.
>SQL> select rowid from dual;
>
>ROWID
>------------------
>AAAACsAABAAAAGkAAA
>
>SQL> select rownum from dual;
>
> ROWNUM
>----------
> 1
>
>SQL> select rownum from dual where rownum=2;
>
>no rows selected
>
>SQL> select rownum from dual where rownum < 2;
>
> ROWNUM
>----------
> 1
>
>
>Hope this was helpful,
>Darrell
>
>
>
>
>>>> [EMAIL PROTECTED] 03/19/03 03:43AM >>>
>Hello list,
>
> I wanted to know the concept of Rownum.. Is it similar to Row Id ?
>
>Thanks and Regards,
>Santosh
>
>
>----------------------------------------------------------------------------
>----
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Darrell Landrum
> INET: [EMAIL PROTECTED]
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
= = = = = = = = = = = = = = = = = = = =
������������������
��
�������������������̶�
[EMAIL PROTECTED]
��������������������2003-03-19
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?GB2312?Q?=C1=F5=BC=CC=B6=AB?=
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
