Re: How to retrieve last row!!!!

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 24 Jun 1999 19:23:52 GMT
Message-ID: <377384ca.3115680_at_newshost.us.oracle.com>


A copy of this was sent to paulcinvt_at_aol.com (PaulCinVT) (if that email address didn't require changing) On 24 Jun 1999 19:18:11 GMT, you wrote:

>>>Rows get inserted all over in a table, not just at the "bottom" (not that
>there
>>>is a bottom to a table either)
>
>What about when one uses the Insert /*+Append */...:-)
>
>
>
>Paul in VT

Insert append just uses 'new' blocks that haven't been used before. They are not 'at the bottom' of the table -- there just is no such concept as 'top', 'bottom', or 'middle' of a table.

  In general -- rows get inserted all over the place -- not just at the "bottom" (not that there is a bottom).

-- 
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Thu Jun 24 1999 - 21:23:52 CEST

Original text of this message