title: ORA-32795: cannot insert into a generated always identity column
body: <p>Guys I am trying to execute below insert statement and I keep getting the error:</p>
  
  <blockquote>
    <p>cannot insert into a generated always identity column</p>
  </blockquote>
  
  <p>the statement is :</p>
  
  <pre><code>INSERT INTO leaves_approval 
  SELECT * 
  FROM   requests_temp r 
  WHERE  r.civil_number = 33322 
         AND r.request_id = (SELECT Max(s.request_id) 
                             FROM   requests_temp s)
  </code></pre>