Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sql query`

Re: sql query`

From: SW <flyhorse_127_at_hotmail.com>
Date: 21 Dec 2004 23:55:03 -0800
Message-ID: <1103702103.573952.153510@c13g2000cwb.googlegroups.com>


What's the reason you want to select the last inserted row? While inserting rows into a table, Oracle will look up those blocks on the segment's free list to store the rows. We don't exactly know which one will be chosen. However, there can be several ways to do this. e.g. trigger, redo log probe using log miner and so forth. Received on Wed Dec 22 2004 - 01:55:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US