title: SQL INSERT INTO simultaneously in 2 tables in apex oracle
body: <p>I have a script:
  I write the data in test2!</p>
  
  <pre><code>INSERT INTO test2 (val)
  SELECT    SUBSTR (:P1_FIRST, 1, 1)
        || TO_CHAR (
              (  TO_NUMBER (REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + LEVEL
               - 1))
           AS val
   FROM dual
   CONNECT BY LEVEL &lt;=
                  TO_NUMBER (
                     REGEXP_SUBSTR (:P1_LAST, '\d+$'))
               - TO_NUMBER (
                     REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + 1;
  </code></pre>
  
  <p>I want to write it in another table myself.I want to write it down all in one request</p>
  
  <pre><code>INSERT INTO test3 (val,data_area,data_add )
  SELECT    SUBSTR (:P1_FIRST, 1, 1)
        || TO_CHAR (
              (  TO_NUMBER (REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + LEVEL
               - 1))
           AS val,
          (select data_area from SEC_USERS_LIST where login =   LOWER(:APP_USER)) as data_area, 
            (select to_char(sysdate, 'dd.mm.yyyy hh24:mi:ss') "Right Now" from dual )  as data_add 
   FROM dual
   CONNECT BY LEVEL &lt;=
                  TO_NUMBER (
                     REGEXP_SUBSTR (:P1_LAST, '\d+$'))
               - TO_NUMBER (
                     REGEXP_SUBSTR (:P1_FIRST, '\d+$'))
               + 1;
  </code></pre>