title: Select a column from dual and populate it with different values
body: <p>Hi I am on Oracle and need some help.</p>
  
  <p>I am creating a select statement that generates a and 3 columns and end_date, table_name &amp; kpi using the dual table. I have created the first two columns however for the third column I want to populate it with 4 different kpis for each date and I am not sure how to do this as I can only populate it with one value. </p>
  
  <pre><code>SELECT TRUNC (SYSDATE, 'iw') - LEVEL AS end_date, 'MyTable' AS table_name , 'kpi_1' as kpi
    FROM DUAL CONNECT BY LEVEL &lt;= 7
  </code></pre>
  
  <p>Your help will be very much appreciated.</p>
  
  <p>This is the output I would like to see</p>
  
  <p><a href="https://i.stack.imgur.com/ryz2x.png" rel="nofollow noreferrer">enter image description here</a></p>