title: Right Parenthesis Error?
body: <pre><code>create table sales_order(
      order_no varchar2(6) Primary Key check(order_no like 'O%'),
      order_date date,
      client_no varchar2(6) foreign key references client_master(client_no),
      dely_address varchar2(25),
      salesman_no varchar2(6) foreign key references salesman_master(salesman_no),
      dely_type char(1) default 'F' check(dely_type like 'F' OR dely_type like 'P'),
      billed_yn char(1),
      dely_date date check (dely_date &gt; order_date),
      order_status varchar2(10) check(order_status IN ('In Process','Fulfilled','BackOrder','Cancelled'))
  );
  </code></pre>
  
  <p>When I am trying to execute this query it displays </p>
  
  <blockquote>
    <p><strong>ORA-00907: missing right parenthesis</strong>. Don't know where right parenthesis is missing.</p>
  </blockquote>