In the application we are using having the schema name different on each environment. I am creating the report and the SQL query should be same for all the environment. As the schema name is different in each environment, I am trying to write a query to pull schema name to append it before the table name.
- E.g.
Owner schema: dev_db
Reporting Schema: report_db
Table Name: Catalog
Query: select * from catalog.
I wanted to bind the owner value (select owner from all_tables where table_name = 'CATALOG') to the reporting query.