Quote Originally Posted by dbasan
Pascal01 needs the first row and the last row as inserted in the table. I know there is no first and last row concept in Oracle. He needs the way data are entered in the table first callled first data and the last as last data as it is available at a point in time. Guys test for yourself
Now try it on an index-organized table, or a cluster, or a partitioned table, or in a parallel query environment, or where there's an index on your column "I" (especially a descending index) ...