title: oracle - create a view with a primary key
body: <p>This question is a duplicate in meaning still I have to clarify it. Oracle documentation specifically <a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm#sthref8266" rel="nofollow">says</a> that it is possible to specify a primary key in <code>CREATE VIEW</code> clause(11g docs has the same notion) . Yet when I try to do it like this:</p>
  
  <pre><code>create or replace view ABC(A, B, C, CONSTRAINT A_PK PRIMARY KEY (A)) ....
  </code></pre>
  
  <p>I get <code>ORA-00922: missing or invalid option</code> pointing at "primary key" phrase. The question is, is it me or is it something wrong with Oracle Documentation?</p>