title: Insert into table with one column value as select query
body: <p>My code is something like this</p>
  
  <pre><code>insert into table (A,B,C,D) values
  ('abb','select appCode,pkid from table where party_id='||party_id,sysdate,user);
  </code></pre>
  
  <p>The <code>party_id</code> here is varchar and it comes as IN clause in Stored proc, So if partyid comes as 123 in stored procedure
  Then I want to see the values in database as
  select appCode, pkid from table where party_id='123'</p>
  
  <p>but thats not happening instead it goes as
  select appCode, pkid from table where party_id=123</p>
  
  <p>sugestions please.</p>