Home » SQL & PL/SQL » SQL & PL/SQL » diff btn rowid and rownum
diff btn rowid and rownum [message #19082] Wed, 27 February 2002 10:48 Go to next message
aish
Messages: 44
Registered: March 2001
Member
Can anybody tell me the difference between the rowid and ROwnum

Thank you.
Aish

Report message to a moderator

Re: diff btn rowid and rownum [message #19084 is a reply to message #19082] Wed, 27 February 2002 10:59 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
Rowid identifies the location of the row, whereas rownum is a pseudocolumn that is a count of the rows as they are returned.

15:57:25 ==> select rowid from table1 where rownum < 4;

ROWID
------------------
AAA75HAATAAAJROAAA
AAA75HAATAAAJROAAB
AAA75HAATAAAJROAAC

Report message to a moderator

Previous Topic: Creating table using a select statement
Next Topic: Error Handling
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:47:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.