Are connection specific variables in Oracle SQL Developer possible? -

i using oracle sql developer.

i have 2 connections use lot have 2 schemas same named different, foo , bar foo , bar connection respectively. queries looks basically...

select stuff foo.cooltable; -- foo connection select stuff bar.cooltable; -- bar connection 

what end doing writing both , pressing ctrl + enter on 1 need after switching connections (or switching , forth manually).

what want know if there way have kind of variable specific connection can write 1 , when run query chooses right schema based on connection.

something this:

select stuff <my_var>.cooltable; 

where <mr_var> read text "foo" foo connection , "bar" bar connection.

similar idea of environment variables if helps clarify.

i don't think there in sqldeveloper need.

however use logon trigger on database set default schema login. way can fire queries without using qualifying schema name, just: select stuff cooltable

to setup logon trigger: oracle setting per user default scheme (not altering session)