title: How to have same alias for two column in select in Oracle?
body: <p>I want to create view or table from this select:</p>
  
  <pre><code>Select '12' a, '13' a
  From dual;
  </code></pre>
  
  <p>When I run it alone without create, it's ok and works but when I put</p>
  
  <pre><code>create or replace view_1
  As
  Select '12' a, '13' b
  From dual;
  </code></pre>
  
  <p>It has error:</p>
  
  <blockquote>
    <p>duplicate column name</p>
  </blockquote>