EBR – Moving To The New Edition

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;

Default Editions

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.