title: "Missing right parenthesis": On Delete Set Null On Update Cascade (SQL/Oracle)
body: <p>I'm having (another?) 'Missing right parenthesis' error.</p>
  
  <p>I'm completely new to SQL, so I don't really have much idea what the problem could be.</p>
  
  <p>It doesn't appear to be, actually, a missing parenthesis. But I continually get the error thrown on the "ON DELETE SET NULL ON UPDATE CASCADE" line.</p>
  
  <p>I'd really appreciate any help ascertaining what the problem is.</p>
  
  <p>I'm using Oracle 11g Express to run my .sql file.</p>
  
  <pre><code>CREATE TABLE Hotel
  (hotelNo          CHAR(10)          NOT NULL
  ,hotelName        VARCHAR2(50)      NOT NULL
  ,city             VARCHAR2(50)      NOT NULL
  ,CONSTRAINT PKHotel PRIMARY KEY (hotelNo)
  );
  --
  CREATE TABLE Room
  (roomNo           CHAR(3)           NOT NULL
  ,hotelNo          CHAR(10)          NOT NULL
  ,roomType         VARCHAR2(20)      NOT NULL
  ,price            DECIMAL(6,2)      NOT NULL
  ,CONSTRAINT checkRoomNo CHECK (roomNo BETWEEN 1 AND 100)
  ,CONSTRAINT checkType CHECK (roomType IN ('Single', 'Double', 'Family'))
  ,CONSTRAINT checkPrice CHECK (price BETWEEN 10.00 AND 100.00)
  ,CONSTRAINT PKRoom PRIMARY KEY (roomNo, hotelNo)
  ,CONSTRAINT FKHotel FOREIGN KEY (hotelNo) REFERENCES Hotel(hotelNo)
      ON DELETE SET NULL ON UPDATE CASCADE
  );
  --
  </code></pre>
  
  <p>Thanks a lot. I really appreciate it!</p>