RE: HOW TO SELECT LATEST INSERTED ROW..

Hi,

I feel it is better to have a column having the last updated timestamp and then do a select.

Rgds,
G.Sathish

> ----------
> From: Rana Sengupta[SMTP:ranasengupta_at_umtl.co.in]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, February 21, 2001 5:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: HOW TO SELECT LATEST INSERTED ROW..
>
> Hay,
> U can proceed in following way..........
> create a dummy table having one row one column ;
> Update this value in a row level insert trigger of your concrn table by
> the current row id ( or any key ).
> Next use a statement level insert trigger on that concern table and by
> select that key from dummy table U and perform the
> required opr.
>
> This Row-level & Statement level triggers will be usefull only when U
> inserting 1 row at a time.
> Regards
> Rana Sengupta
> Executive Systems
> Usha Martin Telekom Ltd.
> 11 Dr. U N Bhramchari Road.
> Calcutta - 700017
> Cell Phone: + 91 98300 32780
> Email : ranasengupta_at_umtl.co.in
> Web: www.commandcell.com
>
> ----- Original Message -----
> From: Saurabh Sharma
> To: Multiple recipients of list ORACLE-L
> Sent: Wednesday, February 21, 2001 3:45 PM
> Subject: HOW TO SELECT LATEST INSERTED ROW..
>
> 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
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Sathish_Govindarajan_at_satyam.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).