Client Tools :: How To Use Unix Environment Variables

An application uses one user as a container of objects(this user is stripped of ALL privileges), and other users that can access objects in this unique schema depending on their privileges.

There can be multiple installations of the application in one database, therefore many such schemes. An environment variable APP_UNIQUE_SCHEMA points to a current unique schema.

So instead of typing

select * from my_unique_schema.my_table I want to set a current schema for sqlplus session in glogin.sql.

It would have been nice if I could have entered in glogon.sql the following line

alter session set current_schema=$APP_UNIQUE_SCHEMA;

BUT it does not work. sqlplus does not resolve the reference to an environment variable. I cannot figure out how to get the value of an environment variable in sqlplus.