Hi,

Other than default schema, for some SQL queries I need to access a particular schema. The issue is that the name of that particular schema is different for different environments.

After goggling I found that using this linkI am able to specify the schema name in variable. If that’s true that I have following questions:

1. Will that would for SQL queries in the named query?
2. How to set the value for the variable names?

Thanks in advance.