Oracle rownum function

Question

How I can get rownum in oracle over order by name? i.e In SQL I have a query

  SELECT 
    ROW_NUMBER() OVER(ORDER BY FIRSTNAME) SRL

  FROM   
    [SECURITY].[USERS]

  ORDER BY 
    FIRSTNAME

How will it be in Oracle?

Answer 1

SELECT ROW_NUMBER() OVER(ORDER BY FIRSTNAME)SRL FROM USERS