Oracle Scheduler – Technical Deep Dive

One of the most essential and frequently under utilized database features is that of the Oracle Database Scheduler.

Oracle Database includes Oracle Scheduler, an enterprise job scheduler to help you simplify the scheduling of hundreds or even thousands of tasks.

This session shows how this Scheduler compares with other scheduling systems, including the Oracle Enterprise Manager Cloud Control job system.

First, this session briefly covers the basic features of the Scheduler that are largely self-evident.

Then, it demonstrates how to use Oracle Schedule to create email notifications, create file watchers that are especially useful in a data warehouse environment and create and manage remote databases and multiple destination jobs.

Modals and Dialogs and … Drawers? Now What?

As of APEX 21.2 we have drawers, in addition to modals, dialogs, and popups – now what to use when?

Learn the subtle and not-so-subtle distinctions between APEX modals, popups, dialogs and drawers: Which to use when, why to choose one over the other, and how to use them appropriately in your APEX applications.

We will cover modal and non-modal dialogs, region types and templates, when to use a dialog page vs an inline region, when a drawer is appropriate vs a dialog, when a popup is best vs a declarative alert or confirm dialog.

We will cover caveats and challenges to be aware of with each element type.

Emphasis is on use of declarative APEX elements and documented JavaScript APIs whenever possible, and best practices for employing these various elements in your APEX pages, including specifics for launching from interactive grids.

Attend and gain confidence in your use of modals, dialogs, drawers and enhanced popups in your APEX applications.

Creating and Editing Office documents in APEX

Creating and Editing Office documents in APEX.

With the fast pace of digitalizing businesses, people use more and more documents online.

In this session, I will show a neat way to easily create MS Office documents straight from your Oracle APEX app. End users will be able to create and edit their Word, Excel, and Powerpoint documents straight from the application and merge it with data coming from the database.

We will use APEX Office Edit and APEX Office Print to make it happen!

Introducing Oracle Zero Downtime Migration 21.3

Oracle Zero Downtime Migration (ZDM) is Oracle’s premier solution for a simplified and automated migration experience to the Cloud providing zero to negligible downtime for migration of on-premise production workloads to the Oracle Cloud Infrastructure.

ZDM follows Oracle Maximum Availability Architecture (MAA) principles completely and incorporates products such as GoldenGate and Data Guard to ensure High Availability and an online migration workflow which supports both a logical as well as physical model.

Graphing Grifters: Identify & Display Patterns of Corruption With Oracle Graph Studio

Ever wonder how your bank knows when to text you when a potentially fraudulent transaction appears on its radar?

It’s simple if you know how to apply the right algorithms to financial transactions so that outliers become readily apparent.

These techniques can be applied to just about any anomalous behavior, and property graph technology helps make outliers stand out dramatically.

Through presentations and online demonstrations, this session will:
• Show how to use appropriate ML algorithms already built into Oracle Database to uncover anomalous patterns
• Demonstrate Oracle Graph Studio’s capabilities to identify and display outliers more clearly
• Introduce the basic concepts of PGQL (Property Graph Query Language) to look at tabular data in completely new way

Oracle Database Online Data Reorganization and Redefinition benefits, use cases

As businesses become more web and e-commerce-enabled, high availability computing solutions are becoming increasingly important because of the extremely high cost of application downtime.
According to a Gartner Group study, the cost of outages for corporations involved in e-commerce can easily reach millions of dollars per hour.
Therefore, database availability and manageability have become increasingly important in many of today’s mission-critical environments. One way to enhance availability and manageability is to allow users full access to the database during a data reorganization operation.

Oracle’s DB DBMS_REDEFINITION is a compelling package used to ‘online redefine’ tables.
Online redefinition of a table means that changes (inserts/updates/deletes/merges) can be made to the table while modifications to the data are being made.
Join this session to understand the key benefits of Online Data Reorganization and Redefinition.

APEX 22.1: Progressive Web Apps

In the last year, Oracle APEX introduced support for Progressive Web App (PWA) technology.
This is the beginning of a long-term commitment to help APEX developers create apps with deeper integration into desktop and mobile devices.
This session will cover what a PWA is and how it might benefit an APEX app.
It will demonstrate what an APEX PWA can achieve now and present a roadmap for 2023 and beyond.

Process Automation functionality within Oracle APEX

With the release of Oracle APEX 22.1, a journey towards enabling Process Automation functionality within Oracle APEX has started. The new Approvals Component in Oracle APEX 22.1 offers basic Task Management and streamlines Approvals in APEX apps and Workflows under a new Unified Task List. In this session we give an overview and demo of the Approvals Component and how it can be used in applications and provide an outlook on future Workflow functionality within Oracle APEX.

Building process-oriented apps with Oracle APEX and Flows for APEX 22.1

Flows for APEX is an open source extension of Oracle APEX with which you can model and run business processes based on BPMN 2.0.
In this session, I will first give an overview of Flows for APEX and focus on the new features that came with 22.1.

After this, we are going to look at how to integrate your BPMN model with APEX using the plug-ins that ship with Flows for APEX.

Bio: Niels has been working with Oracle APEX since its initial public release back in 2004. Together with a team of APEX specialists, Niels is responsible for delivering high-quality APEX projects.
His contributions to the APEX community range from presenting and publishing articles on to initiating and promoting open source solutions like Flows for APEX.
Niels is an Oracle ACE Director and Director of the development community at the German Oracle User Group (