There are a few ways to switch between editions. In this post I’ll present two of them.
After Logon Triggers
This option creates a trigger in the applicable schemas (or the whole database) that specifies the edition to choose. Here is an example:
CREATE OR REPLACE TRIGGER SET_EDITION AFTER LOGON ON SCHEMA BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET EDITION = new_column'; END;
This option sets the default edition for all subsequent logins to the database. It uses the ALTER DATABASE sytnax.
ALTER DATABASE DEFAULT EDITION = new_column;
Remember these only take effect for subsequent logins. Existing sessions are not affected.
In a later post I’ll explain how to set the edition name at the database service level.
Thanks for reading.