Oracle APEX Developer Professional : 1Z0-770
-- An Oracle APEX application is an HTML interface that exists on
top of database objects such as tables or procedures.
-- APEX App is a collection of pages linked together using
APEX Application
navigation menus, tabs,buttons, or hypertext links
-- Create an application by running the Create Application Wizard
to declaratively assemble pages and navigation
-- A Page is the basic building block of an application
-- Every application consists of one or more pages
-- To view a rendered version of your application, you run or submit
Application Page
it to the Oracle APEX engine.
-- The APEX engine dynamically renders, and processes pages
based on the data stored in database tables.
-- Pages can include application logic (or processes).
-- You can branch from one page to the next using conditional navigation
What Application page can do? -- You can perform calculations, validations and display reports,
calendars, and charts.
-- You view and edit a page in Page Designer.
-- When you run an application, the APEX engine relies on two processes:
-- Show Page is a page rendering process that assembles all the
page attributes (including regions, items, and buttons) into a
How the APEX Engine Renders
viewable HTML page
and Processes Pages
-- Accept Page performs forms page processing, including
computations, validations, processes, and branching.
-- You can use conditions in an application to control how
pages and page components display and when processes,
computations, and validations execute.
, -- Session state enables developers to store and retrieve values for
a user as the user navigates between different application
Session State
pages.
-- Oracle APEX transparently maintains session state and provides
developers with the ability to get and set session state values from
any page in the application
-- A session ID is a unique number assigned a specific user for the
duration of that user's visit (session)
-- The Oracle APEX engine establishes the identity of the user for
Session ID each page request and the session ID to fetch session state from
the database.
-- The most visible location of the session ID is in the URL for
a page request.
https://apex.example.com/ords/mycompany/r/hr-app/update-
employees? session=13766599855150
-- A session is a logical construct that establishes persistence (or
stateful behavior) across page views.
-- Each session is assigned a unique identifier or Session ID.
-- Any number of sessions can exist in the database at the same time
Session
-- A user can also run multiple instances of an application
simultaneously in different browser programs.
-- Sessions are logically and physically distinct from Oracle
database sessions used to service page requests.
-- Friendly URL Syntax
Types of URL Syntax
-- f?p Syntax
-- Applications created using APEX release 20.1
or later use Friendly URL Syntax.
URL syntax -- You can change existing applications to use
Friendly URLs by editing the Friendly URLs
attribute in the application definition.
Creates a URL structure that identifies the address of Oracle APEX,
the application, the page, and uses standard web parameter
Friendly URL Syntax syntax.
-- Friendly URL Syntax creates a URL with the following directory
hierarchy and syntax:
https://hostname:port/ords/r/path_prefix/app_alias/page_alias?
parameters
1. On the workspace home page, click App Builder and then click Create.
2. Click New Application
3. Enter the application name, select an application icon
and then click Set Appearance to change the
appearance.
Steps to Create an Application 4. Save the changes to your application's appearance
Based on Existing Tables 5. Next, click Add Page to add pages to your application
6. Select the page of your choice, enter/select the details
and repeat the step if needed
7. Select Features to include in your application, review the
,settings and click Create Application.
8. Click Run Application
9. Log in to review your application.
, -- Progressive Web Apps (PWAs) leverage modern web APIs giving
users an experience that looks and feels like a native
app.
-- Your APEX apps can easily be defined as
Progressive Web Apps (PWAs) to take
Progressive Web App advantage of advanced caching and improved
performance. These apps can also be installed on
your smartphone of choice with device-
specific installation instructions.
-- You can create a PWA when creating a new
application with the Create Application Wizard,
or by editing attributes of an existing
application.
-- The Oracle APEX application must be served over a secured
What are the requirements for a HTTPS environment, or localhost. If using an unsecured
PWA? environment, PWA features will not be rendered
-- The application Definition, Properties, Friendly URLs attribute must be On
-- Adds the ability to install the app as a Progressive Web App (PWA).
-- Adds a new navigation bar entry named Install App to your application.
-- Optimizes page loading speed on the mobile device.
Improves page load rendering time with a new browser cache
architecture for static files (APEX core files and app files).
Enabling PWA Functionality -- Enables users to install the application on devices.
-- Provides a customizable offline page when users are offline and
cannot request the network.
-- Supports hooks into the service worker code for a fully
customizable PWA experience.
1. Interactive Report
2. Interactive Grid
3. Classic Report
Report Types
4. Faced Search
5. Smart Filters
6. Cards
1. On your Workspace home page, click App Builder and click Create.
2. Select New Application and enter the application details.
Steps to Create a Report Using the
3. Click Add Page.
Create Application
4. In the Add Page dialog, select a report of your choice.
Wizard
5. Enter the page details like name, source, and type.
6. Accept the defaults and click Create Application.
-- An Oracle APEX application is an HTML interface that exists on
top of database objects such as tables or procedures.
-- APEX App is a collection of pages linked together using
APEX Application
navigation menus, tabs,buttons, or hypertext links
-- Create an application by running the Create Application Wizard
to declaratively assemble pages and navigation
-- A Page is the basic building block of an application
-- Every application consists of one or more pages
-- To view a rendered version of your application, you run or submit
Application Page
it to the Oracle APEX engine.
-- The APEX engine dynamically renders, and processes pages
based on the data stored in database tables.
-- Pages can include application logic (or processes).
-- You can branch from one page to the next using conditional navigation
What Application page can do? -- You can perform calculations, validations and display reports,
calendars, and charts.
-- You view and edit a page in Page Designer.
-- When you run an application, the APEX engine relies on two processes:
-- Show Page is a page rendering process that assembles all the
page attributes (including regions, items, and buttons) into a
How the APEX Engine Renders
viewable HTML page
and Processes Pages
-- Accept Page performs forms page processing, including
computations, validations, processes, and branching.
-- You can use conditions in an application to control how
pages and page components display and when processes,
computations, and validations execute.
, -- Session state enables developers to store and retrieve values for
a user as the user navigates between different application
Session State
pages.
-- Oracle APEX transparently maintains session state and provides
developers with the ability to get and set session state values from
any page in the application
-- A session ID is a unique number assigned a specific user for the
duration of that user's visit (session)
-- The Oracle APEX engine establishes the identity of the user for
Session ID each page request and the session ID to fetch session state from
the database.
-- The most visible location of the session ID is in the URL for
a page request.
https://apex.example.com/ords/mycompany/r/hr-app/update-
employees? session=13766599855150
-- A session is a logical construct that establishes persistence (or
stateful behavior) across page views.
-- Each session is assigned a unique identifier or Session ID.
-- Any number of sessions can exist in the database at the same time
Session
-- A user can also run multiple instances of an application
simultaneously in different browser programs.
-- Sessions are logically and physically distinct from Oracle
database sessions used to service page requests.
-- Friendly URL Syntax
Types of URL Syntax
-- f?p Syntax
-- Applications created using APEX release 20.1
or later use Friendly URL Syntax.
URL syntax -- You can change existing applications to use
Friendly URLs by editing the Friendly URLs
attribute in the application definition.
Creates a URL structure that identifies the address of Oracle APEX,
the application, the page, and uses standard web parameter
Friendly URL Syntax syntax.
-- Friendly URL Syntax creates a URL with the following directory
hierarchy and syntax:
https://hostname:port/ords/r/path_prefix/app_alias/page_alias?
parameters
1. On the workspace home page, click App Builder and then click Create.
2. Click New Application
3. Enter the application name, select an application icon
and then click Set Appearance to change the
appearance.
Steps to Create an Application 4. Save the changes to your application's appearance
Based on Existing Tables 5. Next, click Add Page to add pages to your application
6. Select the page of your choice, enter/select the details
and repeat the step if needed
7. Select Features to include in your application, review the
,settings and click Create Application.
8. Click Run Application
9. Log in to review your application.
, -- Progressive Web Apps (PWAs) leverage modern web APIs giving
users an experience that looks and feels like a native
app.
-- Your APEX apps can easily be defined as
Progressive Web Apps (PWAs) to take
Progressive Web App advantage of advanced caching and improved
performance. These apps can also be installed on
your smartphone of choice with device-
specific installation instructions.
-- You can create a PWA when creating a new
application with the Create Application Wizard,
or by editing attributes of an existing
application.
-- The Oracle APEX application must be served over a secured
What are the requirements for a HTTPS environment, or localhost. If using an unsecured
PWA? environment, PWA features will not be rendered
-- The application Definition, Properties, Friendly URLs attribute must be On
-- Adds the ability to install the app as a Progressive Web App (PWA).
-- Adds a new navigation bar entry named Install App to your application.
-- Optimizes page loading speed on the mobile device.
Improves page load rendering time with a new browser cache
architecture for static files (APEX core files and app files).
Enabling PWA Functionality -- Enables users to install the application on devices.
-- Provides a customizable offline page when users are offline and
cannot request the network.
-- Supports hooks into the service worker code for a fully
customizable PWA experience.
1. Interactive Report
2. Interactive Grid
3. Classic Report
Report Types
4. Faced Search
5. Smart Filters
6. Cards
1. On your Workspace home page, click App Builder and click Create.
2. Select New Application and enter the application details.
Steps to Create a Report Using the
3. Click Add Page.
Create Application
4. In the Add Page dialog, select a report of your choice.
Wizard
5. Enter the page details like name, source, and type.
6. Accept the defaults and click Create Application.
