[begonner] Getting a row from a table

Hello,
I have a table with 27 records.

SQL> select count(*) from mytable;

  COUNT(*)

        27

#so why I don't get anything when I :

select * from mytable where rownum = 25; No rows selected

#I also don't get anything when I try

select * from mytable where rownum > 25; No rows selected

Thanks in advance.

--
Francesco Marchioni
Java Developer

"In a world without fences, why does one need Gates ?"
Anonymous