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:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> 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 : [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
