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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about triggers

Re: Question about triggers

From: <carla_rj_at_imagelink.com.br>
Date: 25 May 2006 07:49:54 -0700
Message-ID: <1148568594.284217.16940@j33g2000cwa.googlegroups.com>


No, you don't need to commit T2 before T1, but you need to update it before.

It's necessary because if when you you update a data and select the updated data you will see it correctly. The other users will only see the changes after your commit. So if you do the update on T2 when you update T1 the transaction will be able to see T2.

I hope it help you. Received on Thu May 25 2006 - 09:49:54 CDT

Original text of this message

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