questions - Question:What is ROWNUM and ROW_NUMBER ?

  1. ROWNUM is a pseudocolumn which is the number assigned to each row retrieved.
  2. - ROW_NUMBER is an analytic function which does something similar, but has all the capabilities of PARTITION BY and ORDER BY clauses..

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.