Using a global variable
In my development environment I have two database schemas one call AAA and the second call BBB.
We have only one scenraio which use BBB. It means that all my SQL queries are set with : select * from BBB.mytable
The problem is in qualification and production environment the schema is AAA.
My question, How can i use a global variable which is set to BBB for developement and AAA otherwise ?