title: Is it possible to create index on view columns?
body: <p>When I am creating an index on a view, it shows the following error:</p>
  
  <blockquote>
    <p>ORA-01702: a view is not appropriate here</p>
  </blockquote>
  
  <pre><code>create view xx_emp for select * from emp; 
  </code></pre>
  
  <p>What is the reason behind it?</p>