title: Oracle Sql Check Constraint
body: <p>What I want to do is simple and below are details. I have two tables.</p>
  
  <pre><code>Create Table Event(
  IDEvent number (8) primary key,
  StartDate date not null,
  EndDate date not null
  );
  </code></pre>
  
  <p>This is fine.</p>
  
  <p>Here is second table.</p>
  
  <pre><code>Create Table Game(
  IDGame number (8) primary key,
  GameDate date not null,
  constraint checkDate 
  check (GameDate &gt;= to_date(StartDate references from Event(StartDate)))
  );
  </code></pre>
  
  <p>The constraint checkDate is to check if the date is bigger than the startdate. While checking I'm getting error : <code>Missing right parenthesis</code>.</p>
  
  <p>My  question is, If this is possible to do then why it is giving me an error?</p>