title: Return auto increment value in Oracle SQL Insert statement?
body: <p>I have Insert statement that should return Auto Increment column value. Here is example of my insert:</p>
  
  <pre><code>myQuery = new query();
  myQuery.name = "insertRec";
  myQuery.setDatasource("db");
  mySQL = "
      INSERT INTO myTable (
          First, Last, Email, ActionDate 
      )VALUES(
          :first, :last, :email, :actiondt
      )
  ";
  
  myQuery.setSQL(mySQL);
  myQuery.addParam(name="first", cfsqltype="cf_sql_varchar", value="#trim(form.first)#", maxlength="50");
  myQuery.addParam(name="last", cfsqltype="cf_sql_varchar", value="#trim(form.last)#", maxlength="50");
  myQuery.addParam(name="email", cfsqltype="cf_sql_varchar", value="#trim(form.email)#", maxlength="320");
  myQuery.addParam(name="actiondt", cfsqltype="cf_sql_timestamp", value="#now()#");
  myQuery.execute().getResult();
  //result = myQuery.execute().getResult(); This line is commented because I was getting error message that test variable is not defined. Not sure why since test is declared and equals to myQuery.execute().getResult();
  </code></pre>
  
  <p>After I run this code record will appear in the table. Result set looks like this:</p>
  
  <pre><code>RecordID  First  Last       Email        ActionDt
     7      John   Woss   jwoss@gmail.com  16-NOV-18
  </code></pre>
  
  <p>As you can see <code>RecordID</code> (auto increments) is there. I would like to get that value once myQuery is completed. How to achieve that?</p>