title: Exception join Oracle
body: <pre><code>              SELECT a.product_name
                     , a.product_price
                     , c.restaurant_id
                     , c.restaurant_name
                     , c.phone_number
                  FROM MENU a 
  RIGHT EXCEPTION JOIN RESTAURANT c 
                    ON a.restaurant_id=c.restaurant_id 
              ORDER BY a.restaurant_id
                     ;
  </code></pre>
  
  <p>i am getting a error </p>
  
  <blockquote>
    <p>Answer: The ORA-00905 is given to indicate a malformed statement, where the Oracle parser indicates that a statement has a missing keyword. </p>
  </blockquote>
  
  <p>The Oracle docs note this on the ora-00905 error: </p>
  
  <blockquote>
    <p>Cause: A required keyword is missing. ... Upon encountering ORA-00905, you must correct syntax because there is a missing keyword.</p>
  </blockquote>