[oracle] set default schema

To set default schema for all queries (and avoid prefixing all tables), execute below statement in active db session:

Alter session set current_schema = USR

where “USR” is schema to use by default

Post a Comment

Your email is never published nor shared. You're allow to say what you want...