title: Oracle INSERT INTO with select and values
body: <p>I'm trying to insert some values into a table from a select statement and some hardcoded values, but I'm not sure what the syntax would be. When I try I get an error saying there are not enough values so I know it's not reading my select statement correctly. Any help is appreciated.</p>
  
  <pre><code>insert into INSERT_STG
  values(
    (select code,
            acct,  
            to_char(sysdate, 'mmddyy'),
            amt      
    from schema.table),
    'Partners',
    'city',
    'st',
    'Y',
    null,
  </code></pre>
  
  <p>);</p>