title: Data manipulation in APEX 20 oracle
body: <p>Currently I am performing dynamic action (executing server side code) where I am selecting the values from two different tables (XYZ &amp; ABC) performing calculation and inserting into another table (ABC_TEMP) and creating a report view out of that in apex(v20)
  Below is what I am performing.</p>
  <pre><code>BEGIN 
          INSERT INTO ABC_TEMP (
              A1,           --&gt; VARCHAR2(4000)
              B1,           --&gt; VARCHAR2(4000)
              C1,           --&gt; NUMBER
              D1,           --&gt; NUMBER
              E1,           --&gt; NUMBER
              F,            --&gt; NUMBER
              G1,           --&gt; NUMBER
              H3,           --&gt; NUMBER
              I3,           --&gt; NUMBER
              J,            --&gt; NUMBER
              K,            --&gt; NUMBER
              L,            --&gt; NUMBER
              timestamp     --&gt;timestamp(6)
              )
          VALUES (
              :A_SELECT, 
              :B_SELECT, 
              :C_SELECT,
              (SELECT D2 FROM XYZ WHERE B2 = :B_SELECT AND C2 = :C_SELECT),
              (SELECT E2 FROM XYZ WHERE B2 = :B_SELECT AND C2 = :C_SELECT),
              (SELECT SUM(D2 + E2) FROM XYZ WHERE B2 = :B_SELECT AND C2 = :C_SELECT),
              (SELECT G2 FROM XYZ WHERE B2 = :B_SELECT AND C2 = :B_SELECT),
              (SELECT H2 FROM ABC WHERE A2 = :A_SELECT AND P2 = 'mock1' AND SE = 'mock2' AND Q2 = 'val1'),
              (SELECT H2 FROM ABC WHERE A2 = :A_SELECT AND P2 = 'mock1' AND SE = 'mock2' AND Q2 = 'val2'),
              (:J),  --&gt; This value is derived from `ABC_TEMP` table only by dividing I3 BY F 
              (:K),  --&gt; This value is derived from `ABC_TEMP` table only by dividing H3 BY G1 
              (:L),  --&gt; this value is derived from  low of J &amp; K column 
              (CURRENT_TIMESTAMP)
              );
  END;
  </code></pre>
  <p>My question is how do I set the values of column J,K,L in the same query as it involves selecting from the same table and performing calculation on top of it where I am inserting data.
  if this is not possible what can be other approach out here.</p>