title: Creating view in oracle using multiple queries
body: <p>I have 2 tables:</p>
  
  <pre><code>create table my_users
  ( userid number,
    username varchar(20)
   );
  
  create table all_users
  ( userid number,
    username varchar(20)
   );
  </code></pre>
  
  <p>I want to create a <strong>view</strong> which is equivalent to:</p>
  
  <pre><code>select * from all_users;
  MINUS
  select * from my_users;
  </code></pre>
  
  <p>However, I'm getting an error when I try to create the view using the following:</p>
  
  <pre><code>create of replace view 'vw_users' as
  select * from all_users;
  MINUS
  select * from my_users;
  </code></pre>
  
  <p>I'm using Oracle12c database.</p>