Add enum type column to table
<p>im trying to add a new column to my existing table 'Results', and it seems to be very easy but I cant see the mistake.</p>

<p>Here is my code:</p>

<pre><code>SQL&gt; Alter table results add column CAL ENUM('A','B');


ERROR at line 1: ORA-00904: : invalid identifier
</code></pre>

<p>What am I missing?</p>

<p>I've read this from <a href="http://www.w3schools.com/sql/sql_alter.asp" rel="nofollow">w3</a> and this from <a href="http://www.java2s.com/Code/SQL/Data-Type/UseALTERTABLEtoconvertthenamecolumntoanENUMthatliststhecolorsinthedesiredsortorder.htm" rel="nofollow">java2s</a> but cant see the difference to mine.</p>

<p>Thanks, and sorry for the dumb question.</p>