Set Current Oracle Schema

To set the current Oracle schema that objects/queries will executed against, run the following code:
ALTER SESSION SET CURRENT_SCHEMA=FOO;