why am i not getting result.....

[pras]

Hi everybody,
i am trying to get the result using the rownum...
i tried the follo

SQL> desc tempinsert
Name Null? Type
----------------------------------------- -------- ----------------------------
MAILMESSAGE VARCHAR2(2000)

SQL> select * from tempinsert;

MAILMESSAGE
--------------------------------------------------------------------------------
1,I101,,,
2,i102,,,

SQL> select rownum,mailmessage from tempinsert;

ROWNUM
----------
MAILMESSAGE
--------------------------------------------------------------------------------
1
1,I101,,,

2
2,i102,,,


SQL> select rowid,mailmessage from tempinsert;

ROWID
------------------
MAILMESSAGE
--------------------------------------------------------------------------------
AAAGiFAAFAAAAxOAAA
1,I101,,,

AAAGiFAAFAAAAxOAAB
2,i102,,,


SQL> select mailmessage from tempinsert where rownum = 1;

MAILMESSAGE
--------------------------------------------------------------------------------
1,I101,,,

SQL> select mailmessage from tempinsert where rownum = 2;

no rows selected


my prob is why am i not getting the result from the last query....

thanks in advance
pras

[jmodic]

http://otn.oracle.com/docs/products/...elem.htm#33158