Home » SQL & PL/SQL » SQL & PL/SQL » what is rowid and rownumber
what is rowid and rownumber [message #253029] Sat, 21 July 2007 10:30 Go to next message
nagaraju.ch
Messages: 98
Registered: July 2007
Location: bangalore
Member

what is thedifference between rowid and rownumber. where can we use them?

this is my mail id: ch.nagaraju008@gmail.com
Re: what is rowid and rownumber [message #253030 is a reply to message #253029] Sat, 21 July 2007 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
One exists the other not.

ROWID
ROWNUM

Regards
Michel
Re: what is rowid and rownumber [message #253031 is a reply to message #253029] Sat, 21 July 2007 11:09 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
And ROW_NUMBER is an analytic function component.
Re: what is rowid and rownumber [message #253037 is a reply to message #253029] Sat, 21 July 2007 17:23 Go to previous messageGo to next message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
And you probably shouldn't make your email address public.
Re: what is rowid and rownumber [message #253056 is a reply to message #253037] Sun, 22 July 2007 00:48 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's just an gmail address; in other words, nothing.

Regards
Michel
Previous Topic: RETRIEVING THE DATA FROM MULTIPLE TABLES
Next Topic: Login Problem
Goto Forum:
  


Current Time: Fri Dec 09 09:51:27 CST 2016

Total time taken to generate the page: 0.08376 seconds