title: Dynamic Value in SQL Select Partition
body: <p>As the title say, is it possible to put a dynamic value in Paritition during <strong>SELECT</strong>?<br>
  I've been searching around for the answer in stack and i can't find a solution to this.</p>
  
  <p>Example</p>
  
  <pre><code>SELECT
      TB1.TB_ID,
      TB1.EFF_DATE
  FROM
      TABLE TABLE1 PARTITION (D20191230) TB1, TABLE2 PARTITION (D20191230) TB2
  WHERE
      TB1.EFF_DATE &gt;= TO_DATE(:p_req_date, 'yyyymmdd') 
  AND 
      TB1.EFF_DATE &lt; TO_DATE(:p_req_date, 'yyyymmdd') + 1
  AND
      TB1.TB_ID = TB2.TB_ID
  </code></pre>
  
  <p>Is it possible to turn Partition value into</p>
  
  <pre><code>('D' + :p_req_date)
  </code></pre>
  
  <p>where :p_req_date will also be in yyyymmdd</p>
  
  <p><br></p>
  
  <p>I've tried concat and subquery but nothing seems to click.</p>
  
  <p>Any help would be appreciated, Thank You!!</p>