Re: Rownum

From: Darrell Landrum <dlandrum_at_zalecorp.com>
Date: Wed, 19 Mar 2003 07:06:00 -0600
Message-Id: <24715.322348@fatcity.com>

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

>>> vsantosh_at_psi.soft.net 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

---

Received on Wed Mar 19 2003 - 07:06:00 CST