Oracle APEX 23 Course For Beginners

Oracle APEX 23 Course For Beginners
Oracle APEX 23 Course For Beginners

Tuesday 24 January 2023

How To Add Components To Every Application Page Using Global Page In Oracle APEX

A global page (usually numbered Page 0) functions as a master page in your application. The Application Express engine renders all components you add to a Global page on every page within your application. You can further control whether the Application Express engine renders a component or runs a computation, validation, or process by defining conditions. When you create a new application, Oracle APEX creates three default pages for the application. These are Page 1 (Home), Page 9999 (Login Page), and Page 0 (Global Page). You can also create the Global Page manually at a later development stage through the Create Page button and selecting Global Page as the page type. Note that the Global Page option appears on the Create a Page wizard screen only when the application does not already have a Global page. 

In this tutorial, I’ll use the Global Page to display two buttons on every application page. The first button will allow users to download the source of your application, while the second one will take them to the PayPal site to make payments. The two buttons are highlighted in the following figure:


Here are the steps to see how things work through the Global Page:

1.    Go to https://www.paypal.me/ and create a link to receive payments – mine looks like this https://www.paypal.me/techmining69.

2.    Export your application file, compress it using WinZip or WinRar utilities, and upload it to your application’s file repository through the Static Application Files option in Shared Components. 

3.    Now, open the Global Page of your application, which is usually labeled as 0 - Global Page.

4.    If the page is empty, add a breadcrumb region to it and set the following attributes for the region:

Property

Value

Title

Breadcrumb

Type

Breadcrumb

Breadcrumb (under Source)

Breadcrumb

Position

Breadcrumb Bar

Template

Title Bar

Region Title (under Template Options)

Use Current Breadcrumb Entry

 5.       Next, add two buttons to the region, as follows:

Property

Values – Button1

Values – Button2

Name

DOWNLOAD

PAY

Label

Download App

Pay

Region

Breadcrumb

Breadcrumb

Button Position

Next

Next

Button Template

Text with Icon

Text with Icon

Hot

No

Yes

Style (under Template Options)

Simple

Simple

Icon

fa-download

fa-money

Action

Redirect to URL

Redirect to URL

Target Type

URL

URL

URL

#APP_IMAGES#MyApp.rar

https://www.paypal.me/techmining69

Type (under Server-side Condition)

Current Page != Page

Current Page != Page

Page

9999   (don’t show on the login page)

9999   (don’t show on the login page)

Save the Global Page and then run your application. The two buttons should appear on every application page, except for the login page. Click the buttons to test their respective actions.


For Visual Instruction Watch This Video      

Display Data Dynamically In A Gauge Chart

In this tutorial, we will learn how to display customer's ordered data in a gauge chart dynamically. As you choose a customer name from ...