title: Insert into table using result set of dual query?
body: <p>I have a table, <code>edgar_t100</code> and which is a table of one column, named ID. I need it to have 100 rows where each row/column intersection is just the number of the row. Obviously I don't want to do this by writing insert clauses, so I thought about using the <code>dual</code> table from Oracle.</p>
  
  <p>If I do, <code>select rownum as ID from dual connect by rownum &lt;= 100</code>, then I get a nice table that captures exactly what I want. </p>
  
  <p>Is there a way to do something like the following: </p>
  
  <p><code>insert into edgar_t100 values (select rownum as ID from dual connect by rownum &lt;= 100)</code> 
  (Obviously that doesn't work and I want to do this using SQL)</p>