Say for example, the table is partioned based on Join Date.
1. How do i specify the partition name in WHERE clause dynamically
2. How do i specify the partition name in FROM clause dynamically
Iam not using PL/SQL(not required). I use only SQL.
Table Partition is transparent to the end user/developer. If partition key is correct and the column is used in the predicate, oracle automatically does partition pruning. You don't need to specify the partition name dynamically.
Basically, it seems to be that your system design may be wrong. Go back to drawing board.
Can you post the SQL statement that you are trying to do in Business Objects?