title: Error in SQL table creation
body: <p>I want to create a data base table sales_order.</p>
  
  <p>My code is as following: </p>
  
  <pre><code>create table sales_order( 
  ono varchar2(6) check(ono like 'o%'), 
  cno varchar2(6), 
  orderdate date not null, 
  deladder varchar2(30), 
  sno varchar2(6), 
  deltype char(1) check (deltype in('P','F')), 
  bill char(1), 
  delydate date CHECK(delydate&gt;orderdate), 
  orderstatus varcahr2(10) set default('inprocess','fullfilled','backorder' 'cancelled'),   constraint p5 primary key(ono), constraint f3 foreign key(sno) references salesman_master(sno)       );
  </code></pre>
  
  <p>Giving Following Error :</p>
  
  <pre><code> delydate date CHECK(delydate&gt;orderdate),
  *
  ERROR at line 9:
  ORA-02438: Column check constraint cannot reference other columns
  </code></pre>