title: Inserting Data Into Table Using Execute Immediate in Oracle
body: <p>For example, I have some table "Test" which has one column "my_date" . What I am trying to do is adding record to a table using some variable:</p>
  
  <pre><code>query_date := "SELECT sysdate FROM dual";
  EXECUTE IMMEDIATE ('insert into test values query_date');
  </code></pre>
  
  <p>I need to insert the record  to the table in this exact way by constructing string and executing query, however I get error. Is it possible to do so? </p>