Consider this: Transcation begin ' ' Insert on table x ' ' Trascation end;
My client C++ front end is multi-threaded. The above 'transcation' block is in thread -y . I want to know the info. abt' last row inserted into table in this transcation block. Info contains the details like time of insertion of a row and data in that row. I think this sufficely explains what I want. -Anagha -----Original Message----- From: Bruno Wolff III [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:00 PM To: Anagha Joshi Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] Latest transcation On Thu, Jun 19, 2003 at 10:46:22 +0530, Anagha Joshi <[EMAIL PROTECTED]> wrote: > Hi All, > Is there any way to know programatically which is the latest > insert/update occured to a particular table? What are the values which > are inserted/updated to that table? That depends on what you really are trying to do. It sounds like using a sequnce, nextval and currval might work. That could be used to track the latest change in one session. If you try to look at the latest change to a table accross all sessions, things get a bit murky. A more precise description of what you are trying to do might result in some other suggestions. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match