title: Is it possible to have a "deferred check constraint" in Oracle?
body: <p>I was thinking that I'd like to have a "deferred check constraint" in Postgres, but that is apparently <a href="http://www.postgresql.org/docs/9.3/static/sql-set-constraints.html" rel="nofollow">not supported at this time</a> (Postgres 9.3)</p>
  
  <p>Then I saw that Oracle seems to broadly have "deferred" for its constraints, documented <a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200/clauses002.htm" rel="nofollow">here</a>. Therefore, is it true that Oracle 10g+ supports having a "deferred check constraint"?</p>
  
  <p>I might have missed further documentation to the contrary, so I figured to ask here as a double-check, trusting that there are people who actively use Oracle who would know the answer - thus avoiding trial-and-error, wasted hours messing around with Oracle servers.</p>