配置单元中的表名选择查询时如何区分大小写？我想做点什么-
SELECT col1, col2 FROM CASE ${PARAM} WHEN 'val1' THEN table1 WHEN 'val2' THEN table2
SELECT col1, col2
FROM
CASE ${PARAM}
WHEN 'val1' THEN table1
WHEN 'val2' THEN table2
ercv8c1e1#
这是可能的。按以下方式重写查询：
SELECT col1, col2 FROM table1 WHERE '${PARAM}' = 'val1' --only one subquery will be executedunion allSELECT col1, col2 FROM table2 WHERE '${PARAM}' = 'val2'
SELECT col1, col2 FROM table1 WHERE '${PARAM}' = 'val1' --only one subquery will be executed
union all
SELECT col1, col2 FROM table2 WHERE '${PARAM}' = 'val2'
1条答案
按热度按时间ercv8c1e1#
这是可能的。按以下方式重写查询：