Set Up Environment Banner

If you work on many different APEX environments, as I do, from APEX 21.2 you can easily set up a banner that will be visible on the left or the top of the APEX Builder to easily identify the environment.

Environment Bar on the left of the APEX Builder

You can do this on instance or workspace level. To modify this on the instance level you need to log in as instance admin (Manage Instance > Define Environment Banner):

You can also do this with the API:

	begin
	-- instance level
	apex_instance_admin.set_parameter('ENV_BANNER_ENABLE' , 'Y');
	apex_instance_admin.set_parameter('ENV_BANNER_LABEL' , 'Development');
	apex_instance_admin.set_parameter('ENV_BANNER_COLOR' , 'accent-3');
	apex_instance_admin.set_parameter('ENV_BANNER_POS' , 'LEFT');
	commit;
	end;
	/

view raw apex_instance_param_banner.sql hosted with ❤ by GitHub

On the Workspace level, you can do this in Manage Service > Define Environment Banner.

Unfortunately, API for setting Workspace params currently (APEX 21.2.0) doesn't work:

	begin
	-- workspace level
	apex_instance_admin.set_workspace_parameter(:WORKSPACE, 'ENV_BANNER_ENABLE' , 'Y');
	apex_instance_admin.set_workspace_parameter(:WORKSPACE, 'ENV_BANNER_LABEL' , 'Development');
	apex_instance_admin.set_workspace_parameter(:WORKSPACE, 'ENV_BANNER_COLOR' , 'accent-4');
	apex_instance_admin.set_workspace_parameter(:WORKSPACE, 'ENV_BANNER_POS' , 'LEFT');
	commit;
	end;
	/

view raw apex_workspace_param_banner.sql hosted with ❤ by GitHub

Tested in APEX 21.2.0