title: How to add column in a view using ALTER VIEW in sql Oracle 12c
body: <p>INITIAL VIEW CREATED</p>
  
  <pre><code>create or replace view concert_view 
  as
  select concert.concert_id
      from concert, event
  where concert.concert_id=event.concert_id;
  </code></pre>
  
  <p>WHEN I TRIED TO ADD COLUMNS USING</p>
  
  <pre><code>alter view  concert_view as
  select
     cname,edate
     from concert,event
   where concert.concert_id=event.concert_id;
  </code></pre>
  
  <p>I HAVE AN ERROR MESSAGE</p>
  
  <p>alter view  concert_view as<br>
                           *
  ERROR at line 1:
  ORA-00922: missing or invalid option</p>