title: Oracle PL/SQL: how can I use INSERT INTO but select data from different tables?
body: <p>Here's what I want to do:</p>
  
  <p>Insert some data being passed into a procedure into a new table, but also include some data from another table too.</p>
  
  <p>Example:</p>
  
  <p>INSERT INTO my_new_table(name, age, whatever)
  VALUES (names.name, ages.age, passed_in_data);</p>
  
  <p>But that won't work.</p>
  
  <p>I did check another question on here, but it was a bit much for my feeble brain.</p>