I have multiple schemas that I need to query across. The schemas are not know in advance for example:
I need to select across these three schemas from a specific table in each of these schemas. Can I put this query across these three schemas? If so, how can I query across them? Remember, I will not know the schema names ahead of time, so they will need to be built dynamically.
Thank you for your help!