It is quite easy to use a parameter as a table name or in any other portion of a SQL statement, e.g. IN ( ... ) syntax.
Instead of using the ## denotation, use $$. For example:
SELECT * FROM $myValue$ WHERE AGE=#myAge#
Be sure to indicate 'remapResults="true"' in your definition. Using the $$ syntax instead of ## modifies the actual SQL statement, before parameters are applied.
NOTE: The $$ syntax should be used with caution because of it's obvious potential for SQL injection attacks.

This is a great tip! Just what I have been looking for! You made my day
BTW, how do I pass in this parameter from Java code?