title: invalid identifier in update statement in Oracle SQL
body: <p>I have two tables below:</p>
  
  <pre><code>hotel (**hotelNo**, hotelName, city)
  room  (**roomNo**, type, price, hotelNo)
  </code></pre>
  
  <p>In table <code>hotel</code>, <code>hotelNo</code> is the primary key. In <code>room</code> table, <code>roomNo</code> is the primary key and <code>hotelNo</code> is the foreign key.</p>
  
  <p>Now I want to increase the prices of all rooms at the Hyde Park Hotel by 5%. This is my statement:</p>
  
  <pre><code>UPDATE room SET price = price * 1.05
  WHERE room.hotelNo = hotel.hotelNo AND hotel.hotelName = 'Hyde Park';
  </code></pre>
  
  <p>The oracle give me an error says <code>hotel.hotelName</code> is invalid identifier.
  That's why? and how could I accomplish my task?</p>