[SQL] oracle rownum equivalent?

[mikeo]

is there an equivalent to rownum in oracle?

also, where can one find reference to "hidden columns" 
such as OID or, as in oracle, rownum?

thanks,

  mikeo