title: Oracle SQL - ALTER VIEW : ORA-00922: missing or invalid option
body: <p>I want to add a primary key constraint to my column, but Oracle gives me the following error message:</p>
  
  <blockquote>
    <p>ORA-00922: missing or invalid option</p>
  </blockquote>
  
  <p>SQL:</p>
  
  <pre><code>ALTER VIEW view_my_departments
  add CONSTRAINT department_id_pk
      PRIMARY KEY (department_id);
  </code></pre>