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

Full-width Page Layout on specific pages

If you set Body Content Max Width property in Theme Roller of UT theme to some fixed value (other than Auto) your body content will be centered on the screen. 

What if you want to reset this on specific pages and use the full width of the screen?

In this case, you should add the following line of the CSS to the page property Inline CSS: 

If you want to define it in the static CSS file you can also reference it as:

	.page-1 {
	--ut-body-content-max-width: auto;
	}

view raw apex_full_width_page_layout.css hosted with ❤ by GitHub

...or the declarative way - just set region position to Before Content Body and set the margins. 🙂

Tested in APEX 21.1.5