As the title say, is it possible to put a dynamic value in Paritition during **SELECT**?  

I've been searching around for the answer in stack and i can't find a solution to this.

Example

```
SELECT
    TB1.TB_ID,
    TB1.EFF_DATE
FROM
    TABLE TABLE1 PARTITION (D20191230) TB1, TABLE2 PARTITION (D20191230) TB2
WHERE
    TB1.EFF_DATE >= TO_DATE(:p_req_date, 'yyyymmdd') 
AND 
    TB1.EFF_DATE < TO_DATE(:p_req_date, 'yyyymmdd') + 1
AND
    TB1.TB_ID = TB2.TB_ID

```

Is it possible to turn Partition value into

```
('D' + :p_req_date)

```

where :p\_req\_date will also be in yyyymmdd

I've tried concat and subquery but nothing seems to click.

Any help would be appreciated, Thank You!!