SQL> create table test3(a number);

Table created.

SQL> insert into test3 values(5);

1 row created.

SQL> insert into test3 values(1);

1 row created.

SQL> insert into test3 values(2);

1 row created.

SQL> insert into test3 values(100);

1 row created.

SQL> insert into test3 values(3);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test3 where rownum<2;

         A
----------
         5

SQL> select * from test3 where rownum<3;

         A
----------
         5
         1

SQL> select * from test3 where rownum<4;

         A
----------
         5
         1
         2
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
-bash-3.00$ sqlplus arju/arju

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 30 12:31:57 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from test3 where rownum<4;

         A
----------
         5
         1
         2

SQL> create table faq (id number, my_filler varchar2(4000));

Table created.

SQL> insert all
  2  into faq values (1, lpad('x', 4000, 'x'))
  3  into faq values (2, lpad('x', 4000, 'x'))
  4  into faq values (3, lpad('x', 4000, 'x'))
  5  into faq values (4, lpad('x', 4000, 'x'))
  6  into faq values (5, lpad('x', 4000, 'x'))
  7  into faq values (6, lpad('x', 4000, 'x'))
  8  into faq values (7, lpad('x', 4000, 'x'))
  9  into faq values (8, lpad('x', 4000, 'x'))
 10  into faq values (9, lpad('x', 4000, 'x'))
 11  into faq values (10, lpad('x', 4000, 'x'))
 12  select * from dual;

10 rows created.

SQL>
SQL> select id
  2  from   faq
  3  where  rownum < 5;

        ID
----------
         1
         2
         3
         4

SQL>
SQL> delete faq where id between 2 and 6;

5 rows deleted.

SQL> insert into faq values (11, lpad('x', 4000, 'x'));

1 row created.

SQL> select id
  2  from   faq
  3  where  rownum < 5;

        ID
----------
         1
        11
         7
         8