表名格式tSalPluDetail202005、tSalPluDetail202004，都是这种，表前缀+年月的表名

 我的SQL 是这样的，我想要把‘201912’换成todate，这SQL 只是测试，测试结果是软件不支持execute immediate。。

execute immediate(select ts.orgcode as 组织编码,ts.orgname as 名称,ts.rptdate as 报表日期,ts.plucode as 商品编码,ts.pluname as 商品名称,ts.barcode as 商品条形码,ts.unit as 单位,ts.depname as 部门,ts.clsname as 品类,ts.xscount as 销量,ts.price as 售价,ts.hjcost as 含税进价金额,ts.hxtotal as 含税销售金额,ts.hmtotal as 含税毛利

from 'TSALPLUDETAIL'||'201912' ts WHERE  ts.orgcode IN (SELECT orgcode from torgmanage where isenable =1)and ts.depname NOT LIKE '%租%')

有大神吗