title: PL/SQL How to INSERT with a subquery and an argument
body: <p>I have a procedure that requires a string as input</p>
  
  <pre><code>CREATE PROCEDURE testing(MYVAR VARCHAR) AS
  BEGIN
    INSERT INTO mytable VALUES ( (SELECT id FROM articles), MYVAR );  --WRONG
  </code></pre>
  
  <p>The insert query is wrong, basically the table mytable has only 2 fields:</p>
  
  <pre><code>idarticles | variable
  </code></pre>
  
  <p>With the subquery I wanna select all the <code>article ID</code> and insert them as a pair with the MYVAR arg.</p>
  
  <p>How can I do that?
  Thanks</p>