title: Keeping tables consistent during trigger execution?
body: <p>I have a trigger that checks another couple of tables before allowing a row to be inserted. However between the time I check the other tables and insert the row the other tables may get updated.</p>
  
  <p>How do I ensure the tables I'm checking remain in a consistent state until after the new row is inserted? I was thinking of taking locks out but everything I've read boils down to if you are <em>not</em> leaving locking to Oracle you're almost certainly doing it wrong.</p>