Its obvious I hadnt fully understood ROWNUM yet, as you see
we are learning bits and pieces as we go along.
Help me out here, will you? Talk to me like I'm a 10-year old, its ok.
MaryAnn, the best way to understand rownum is to do the following:
SQL SELECT ROWNUM, GENDER
2 FROM
Mary Ann,
Assume that the rows are selected in random order. Primary Keys and Order By exist
for ordering and qualifying your data. If you just select * from EMP2, most likely
the rows willl come back in the order that they were inserted, but this is not
necessarily true, especially if
Oracle does not guarantee the order in which records are retrieved (read in
from the disk or data buffers) nor does Oracle guarantee the order in which
records are presented to you unless you specify an ORDER BY. The ROWNUM is
assigned after Oracle has selected the record to appear in the result
