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

Home -> Community -> Mailing Lists -> Oracle-L -> HOW TO SELECT LATEST INSERTED ROW..

HOW TO SELECT LATEST INSERTED ROW..

From: Saurabh Sharma <saurabhs_at_fcsltd.com>
Date: Wed, 21 Feb 2001 02:27:54 -0800
Message-ID: <F001.002B9566.20010221021524@fatcity.com> 







HI ALL,



how can i select the latest inserted row 
from a table.


i want to select a col value, perform 


some operation on it and update the same to table via a trigger..
it says table is mutating.


i'm inserting rows 1 at a 


time.


 


any suggestions..


thanks in advance.


saurabh 
Received on Wed Feb 21 2001 - 04:27:54 CST












Original text of this message













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