Inserting Data Into Table Using Execute Immediate in Oracle
<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>