SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the difference between RowID and RowNum

525708Aug 4 2006 — edited Aug 5 2006

dear members,

I have a table named 'students' which has 12 rows in it. when i try to execute the query
select * from students
where rownum>10;

it did not give any rows in the output. I tried to give rowid=10 still no rows were retrieved in the output, but if i give rowid<10 then it fetched 9 rows in the output.

my questions are :

1. why rownum is behaving differently in all the 3 cases that i mentioned above?
2. what is the difference between ROWID and ROWNUM?

I am using sql * plus with oracle version 9i. I would appreciate your help.

cheers
sandeep

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2006

Added on Aug 4 2006

5 comments

7,120 views