Creating a new page in Oracle APEX is a fundamental step in building any application. Whether you are designing a form, report, chart, or a dashboard, understanding how to create and configure pages effectively is essential for delivering a seamless user experience. This process involves selecting the appropriate page type, linking data sources, and customizing layout and components to meet your application requirements.
Creating a page in Oracle APEX is a straightforward yet powerful process that allows you to build various types of user interfaces such as forms, reports, charts, and dashboards. Here is a detailed step-by-step guide on how to create a page in Oracle APEX:
-
Log in to Oracle APEX and open your application in the Application Builder.
-
Click on the "Create" button, usually found on the application home page or within the Page Designer interface.
-
Choose the type of page you want to create. Oracle APEX offers multiple page types such as:
-
Form (for data entry and editing)
-
Report (Interactive Report, Classic Report, or Interactive Grid)
-
Chart (various chart types)
-
Dashboard or Blank Page
-
Calendar, Map, or others based on your application needs
-
-
Select the data source for the page. For example, if creating a form or report, select the table or view that the page will interact with. You can also use SQL queries for more customized data retrieval.
-
Configure page settings such as the page name, page number (which is auto-assigned but can be changed), and the page mode (Modal, Inline, or Normal).
-
For forms and reports, configure additional options such as:
-
Which columns or fields to include
-
Display settings (labels, item types, default values)
-
Validation rules for form inputs
-
Interactive Report settings like filters, pagination, and sorting
-
-
Customize the page layout and regions. You can add multiple regions like reports, buttons, charts, or HTML content and arrange them as needed using drag-and-drop in the Page Designer.
-
Define navigation and branching. Set up menu entries or buttons that allow users to navigate between pages or submit forms.
-
Review and adjust authorization and authentication settings to control page access.
-
Click "Create" or "Save" to finalize the page creation.
After creating the page, you can further customize it by adding dynamic actions, processes, and plugins to enhance interactivity and functionality.
By following these steps carefully, you can efficiently create pages that are well-structured, user-friendly, and tailored to your application’s requirements. Oracle APEX’s page creation process is designed to accelerate development while maintaining flexibility and control.
Example
Creating a page in Oracle Application Express (APEX) is a streamlined process that leverages the platform's intuitive tools, such as the Create Page Wizard and Page Designer. Here's a step-by-step guide to assist you:
Initiate the Page Creation Process:
On the application's home page, click the Create Page button.
Choose the Page Type:
APEX offers various page types, including:
Component: Pages like Forms, Reports, Charts, Calendars, etc.
Feature: Functional pages such as About Pages, Access Control, Feedback, etc.
Select the page type that aligns with your requirements.
In this case we are selecting the “Classic” Report.
Configure Page Attributes:
Provide essential details such as:
Page Name: A descriptive title for the page.
Navigation Preferences: Determine if and where the page appears in the application's navigation menu.
Specify the data source or table associated with the page, if applicable.
Finalize and Create the Page:
Review your configurations.
Click Create Page to generate the new page.
Design and Customize Using Page Designer:
APEX's Page Designer offers a drag-and-drop interface for:
Adding or modifying regions and items.
Setting properties and layouts.
Implementing dynamic actions and validations.
Run the page by clicking on the green button on the top right side.
Your page should look very empty and plain like this:
