title: How do i add a column in oracle with Enum values?
body: <p><a href="https://stackoverflow.com/questions/203469/how-to-use-enums-in-oracle">How to use enums in Oracle?</a></p>
  
  <p>The above post gives me an option to create a Enum column while creating a table. But I have a table that is having values. I wanted to add another column with Enum values.</p>
  
  <pre><code>ALTER TABLE CARS **(ADD** BODY_TYPE VARCHAR2(20) 
                      CHECK (BODY_TYPE IN ('COUPE','SEDAN','SUV')) );
  </code></pre>
  
  <p>I'am getting a syntax error near <code>ADD</code>. Please guide.</p>