Within a database session, which syntax allows a user to change to a different schema (NEW_SCHEMA)?
ALTER SESSION SET SCHEMA=NEW_SCHEMA
SET CURRENT SCHEMA TO NEW_SCHEMA
SET SCHEMA NEW_SCHEMA
ALTER DATABASE database name SET DEFAULT SCHEMA NEW SCHEMA
Submit