title: insert values using select with hardcoded values
body: <p>I created a table:</p>
  
  <pre><code>create table table1 
  ( 
      ID NOT NULL,
      NAME VARCHAR2(20) NOT NULL,
      dist1 NUMBER(5,3),
      dist2 NUMBER(5,3),
      dist3 NUMBER(5,3)
  ); 
  </code></pre>
  
  <p>Table2:</p>
  
  <pre><code>select id, name from table 
  </code></pre>
  
  <p>Data:</p>
  
  <pre><code>ID(pk)  |   name(pk)
  -------------------
    86       name1
    86       name2
    86       name3
  </code></pre>
  
  <p>Below is the query I have tried.</p>
  
  <pre><code>INSERT INTO table1(ID, NAME, DIST1, DIST2, DIST3) 
     SELECT distinct customer_ref, plan_name 
     FROM table2
  </code></pre>
  
  <p>for <code>DIST1</code>, <code>DIST2</code>, <code>DIST3</code> - Below values need to be inserted into <code>table1</code> along with <code>ID</code> and <code>name</code></p>
  
  <pre><code>name1  0.8    0.2    0
  name2  1.1    1.2    3.4
  name3  4.5    4.2    5.2    
  </code></pre>
  
  <p>Can any one help me how to insert values into <code>table1</code>.</p>