title: Specify constraints in the CREATE clause in SQL
body: <p>I'm trying to set the Quantity attribute to limit from 1 to 100.
  Does anyone know why this code isn't working?</p>
  
  <pre><code>CREATE TABLE REQUEST (
    OrderID     VARCHAR2(4),
    ProductID   VARCHAR2(2),
    Quantity    INTEGER,
    CONSTRAINT check_quantity CHECK((INTEGER &gt; 0) AND (INTEGER &lt; 101)));
  </code></pre>