Abstracts APEX World 2018




David Peake - Low Code 'Data First' Development

IT Departments, around the world, struggle to meet all of the organization’s application requirements. The majority of the IT budget is spent developing, enhancing, and maintaining only the mission-critical applications. What about all of the other apps required by the business? Many departments form their own ‘Shadow IT’ unit to build the apps they need. More and more Citizen Developers are creating their own apps.

This session will examine how low code tools, such as Application Express, can help redefine the relationship between IT and the rest of the organization. See how these non mission-critical app requirements can be met quickly, reliably, and in a fully supported fashion that fosters collaboration and greatly improves the organization’s IT capabilities. This session will also touch on the breadth of Application Express as a development tool, whereby, apps that start out using low-code can readily be extended to meet mission-critical requirements.




Anthony Rayner - Building APEX Apps for Everybody!



Hearing music for the first time wearing a hearing aid, a deaf person enjoying the theatre wearing smart glasses displaying captions, a remotely assisted blind person being able to walk an unknown busy street, glasses allowing people to perceive colours for the first time; technology smashes through perceived barriers to participation and enjoyment, and truly enables all. This is equally true in the digital world, where, with the right approach, technology can again break through these barriers.

In this session, you will learn what the ‘right approach’ is on the web, and how APEX can help you work towards this. We will also talk about what ‘disability’ really means; how it’s not just about those with obvious disabilities, but either through circumstance or injury, how anyone can face certain limitations or restrictions at some point in their lives, and therefore how thinking inclusively about your design and development can truly benefit everyone. Starting today, let’s all build APEX apps that anyone can use and love!




Overige presentaties Oracle



Anthony Rayner, Shakeeb Rahman & John Snyders - APEX 5.2 New Features


Learn all about many of the new features built into the next major release of Application Express directly from the development team.
These include a brief introduction to REST, and a demonstration of all the new enhancements in APEX 5.2 that make REST much easier and more declarative than it was before. Demonstration of improvements to a number of regions in 5.2 including Interactive Grid and Tree. It will also demonstrate the “new” List View, Reflow Report, and Column Toggle Report regions for responsive desktop apps. Also learn about what is new and improved with Universal Theme in APEX 5.2. This will cover the new features, enhancements, and show you how you can upgrade your Universal Theme applications to the latest and greatest. 

David Peake -
Migrating Oracle Forms to Application Express



Oracle Forms is still being developed and for those whose requirements are being fully met, and are up on a supported release, there is no reason to move off Forms. However, if you are on an older release of Oracle Forms, or need to deliver modern, intuitive, self-service or mobile applications then Application Express is an excellent option. 



John Snyders - Taking control of the client side- Leveraging new JavaScript APIs 


The Number of APEX JavaScript APIs have sharply increased since 5.0 but most of the new stuff wasn't documented. That changes with APEX 5.2. This presentation will demonstrate using these new APIs to customize the user experience.




Shakeeb Rahman - Universal Theme + Mobile



The Universal Theme in APEX 5.2 will see a number of enhancements targetted at developers building responsive apps that are well suited for mobile and small-screen devices. In this tactical session, we'll demonstrate how to migrate jQuery Mobile APEX apps, how to convert mobile-specific components, and how to apply mobile UI patterns with the Universal Theme to build great small screen experiences.




Customer Cases



Pieter Brekelmans en Arjan van der Palen

Oracle APEX goes viral – the antidote to the most commonly used word processor (Intermediate)

Developer and project manager - Transfer Solutions

Co-speaker Pieter Brekelmans - NVIC


"The NVIC (National Poisons Information Center) is the Dutch center for knowledge on clinical toxicology. The NVIC informs medical professionals on the health effects and treatment options in the case of acute poisonings. The NVIC has an extensive information system that supports the daily 24/7 work and contains up to a thousand documents on dangerous substances and medical treatment. These documents are developed  in a common word processor as a tool or template to generate HTML for import into the database for presentation in web browsers.

Using this method, it proved difficult to maintain a constant quality in style, format and layout. In addition, part of the data in these documents was also manually entered into the database. The NVIC wanted to solve both these issues into one innovative, user friendly solution.

This presentation by Transfer Solutions shows you how these issues were solved by replacing a conventional word processor with Oracle APEX. With an important part of their back office system renewed, the NVIC is able to save time, have less difficulties maintaining a structured layout across documents and have all the data in one place.

In this presentation you’ll learn about the power of APEX and how to integrate an intelligent data model, apply UX design and to integrate solutions like Froala HTML editor and APEX Office Print."



Menno Noorloos & Laurens Priemis - Flexibility and short Time-to-market using your own APEX framework (Beginner)

Technical Architect - A.S. Watson


Retail is a fast business where you cannot fall behind on your competitors. Since a few years IT has become an integral part of this (web shops, analytics tools, customer info, etc.). We wanted to develop applications:
- Quickly (both development and user acceptance)
- Uniform
- Secure
- For multiple brands
- For multiple languages
To be able to do this, we chose to build our own framework around APEX like themes, translations, authentication, etcetera.
We will discuss why we think this is the right choice for us.

Olivier van de Perre - Hoe ICO met APEX 2 miljoen auto's per jaar afhandelt. (Beginner)

Oracle APEX Developer - iAdvise Co-speaker Niek Provoost - International Car Operators (ICO) 


Je koopt een nieuwe wagen? Die wordt vast en zeker piekfijn bij je dealer aan jou overhandigd. Wat je niet ziet, is dat die auto al een zware weg van ettelijke tienduizenden kilometers heeft afgelegd. En misschien heeft hij in die periode wel ergens schade opgelopen? ICO zorgt ervoor dat jouw wagen netjes afgeleverd wordt bij je dealer. Daarbij maken ze ijverig gebruik van APEX. ICO is een toonaangevend internationaal bedrijf in de handling en opslag van roll-on/roll-off cargo. Zij staan onder andere in voor het hele transportproces van een nieuwe wagen: vanaf het transport van de autofabriek tot aan de levering bij de dealer. Via enorme terminals in de havens van Antwerpen en Zeebrugge passeren jaarlijks meer dan twee miljoen nieuwe wagens.



Orfeo Ost - Yellowstar and The Bikevertising Company: Renting bikes with an Oracle APEX mobile app! (Intermediate)

R&D Manager - Yellowstar



The Bikevertising Company (X-Bike), operator/supplier of bikes, developed a platform to create a new business model for bike-sharing. The platform enables X-Bike amongst other things to use location management and to predict the needs of customers. The primary reason for the development of the application was a greening project at the Amsterdam Zuid-As – X-Bike won a bike rental tender thanks to the app – but with regards to the future, the communication product, with the underlying neutral Yellowstar platform based on Oracle APEX, offers much more possibilities. The core of the application consists of four elements: Mobility Assets (in this case: bicycles), Persons, Security Asset and Subscription Management. The front-end offers the possibility to serve customers. The user of the application installs it on his or her smartphone, adds credit and starts using it. Steps that belong to renting a bike are reserving one, opening it, checking historical (location) details, see points of interest and navigate. Now we have 3 companies running on the platform with a total of 1800 users cycling around. In this presentation, I would like to show what kind of challenges we got during the project, how we handled with what techniques and how we made a kind of plug & play mobile framework.



Deep Dive



Alan Arentsen - Closing the gap between APEX and JET (Intermediate)

APEX Developer - Arentsen Database Consultancy




"Oracle JET offers a lot of fancy new content to use in your web application. But it isn't a low-code platform. And going from a low-code APEX environment to a hardcode JavaScript platform can be difficult.

Wouldn't it be nice if you could use components and modules made in Oracle JET on a low-code way in APEX.

In this presentation I will show you how to incorporate JET functionality in APEX with low effort. I will use the latest JET version."





Aljaz Mali - Secure your APEX application (Expert)

IT Solutions Architect - Abakus, d.o.o.



APEX security is multi role topic. APEX administrator is responsible (hopefully communicating that with developers) for various instance security setting and enabling and disabling APEX features. The APEX developer is responsible for building secure applications and this means far more than just set up authorization and authentication. Regardless of the security settings, if a developer is not aware of what security is, the application will not be secure. In this presentation I will focus on three areas that every APEX developer should know and understand - Page Access Protection, SQL injection and Cross Site Scripting. In this presentation I will show with practical cases what can go wrong if you application is not properly secured.




Dick Dral - Knockout for APEX (Intermediate)

Developer – Detora

ACE Associate



Knockout is JavaScript library that provides two-way binding and templating. This makes it a powerful tool to create reactive front end applications. This functionality also can be used in Oracle Apex.
With Knockout Apex pages can be made more responsive and more interactive with a limited amount of code. Components on a page can be made to react on changes in other components in a declarative way.
The presentation will start with the explanation of Knockout. How does it work, what does it do, what code do you need to write? Then the integration of Knockout will be into Apex will be discussed. What are the possibilities and limitations in Apex? What are typical use cases? Some Apex pages using Knockout will be demonstrated and explained. These pages will implement both two-way binding and templating.
After attending the audience will know what Knockout can and cannot do for Apex. They have seen the way it can be integrated into Apex.





Roel Hartman - Top Ten Tweaks for the Interactive Grid (Intermediate)

Director – APEX Consulting

ACE Director



The Interactive Grid is introduced in APEX 5.1 as a best of both worlds of Tabular Forms and Interactive Reports. Although a lot of settings are declaratively available within the APEX builder, there are a ton of features built in that are only accessible by JavaScript.
In this session you will learn how to use the most interesting "hidden" features with just a few lines of JavaScript.
Some examples:
- Adding and removing buttons from the Interactive Grid toolbar.
- Adding and removing actions from the toolbar menu.
- Adding and removing functionality from the row level pop up menu.
- Removing complexity on the column level.
- Adding tooltips to a column.
- Changing the layout of columns and headings.
- Refreshing (only) changed records within the grid.
- Removing only deleted records from the grid - without a full refresh.






Alex Nuijten - And Out of Chaos came the perfect APEX application (Beginner)



"It's very easy to create apex applications, probably a little bit too easy. Being productive is one thing, but the fruit of your hard labor should also be maintainable.

By having a clear structure to the application, the development process as well as the maintenance is crystal clear to everyone involved making it much easier to have a successful application.

Low code and agility still means you need to design the application, and that's what this session is about."







Aljaz Mali - APEX Shared Components (Intermediate)



If we check official documentation about Oracle Application Express Shared Components we can read this: "Shared components are common elements that can display or be applied on any page within an application". But once we are logged into APEX and we go to Shared Components, we can see that this definition is true only for just a small part of Shared Components. Under Shared Component we can see a lot of features that we all use and know very well, for example List of Values, Navigation Menu, Lists, …
In this presentation we will look at features of the Shared Components that we all know but are often overlooked or at least we don’t know all the good stuff about them. We will focus on Global Application Items, new features of Build Options in APEX 5.1, Data Load Definitions, Shortcuts and Text Messages. This presentation is not about basic usage of this features, it is about tips and tricks. We will look at how to overcome limitations when we work with Data Load Definitions, how to combine Shortcuts with Text Messages and more...




Christian Rokitta - 3... 2... 1... Lift Off! - Launching a public web application build with APEX! (Intermediate)

Consultant - rokit / smart4apex




"Oracle Application Express is commonly used to build internal business applications, used as a modern replacement for Oracle Forms. The framework, structure and components are optimized to enable rapid, declarative (low code) development cycles.

But Oracle Application Express, and it’s undelaying architecture, is very suitable for other purposes too. Public websites are often build with a PHP, MySQL backend, running Content Management Systems (CMS) or web shop applications. When building a web application for public access, that cannot be served with an off-the-shelf system, why not use Oracle technology? Especially for you, being very familiar with Oracle technology. Because it’s expensive? Well, using the Oracle XE database, Application Express and ORDS is free, isn’t it?

So, how suitable is this free Oracle architecture for building public facing web applications? Whether you are a hobbyist or want to start up a new internet business, there are a few things you will have to investigate and plan:

There are a couple of aspects we need to investigate:

- User Interface

- Mobile support

- Scalability

- Internationalization

- Visibility (Search Engine Optimization)

- Monitoring

- Privacy

- Earning money

All aspects will be explained and demonstrated on a real world APEX application, providing a service to private internet users. At the end of this session, I will officially launch the German version of this web application I have built with Oracle Application Express"




Craig Sykes - APEX AI: Communicating with your application using Chatbots and Speech Recognition (Intermediate)

Development Consultant – Explorer



This session will discuss how you can integrate Natural Language Processing and AI technologies with your APEX application.  The session will cover how to configure Amazon Alexa and external text-based chatbots to interface with and gather data from your APEX applications and Oracle database.




Dietmar Aust - Oracle APEX 5.2 - The Golden Nuggets (Intermediate)

Freelancer – OPAL Consulting




"Every new APEX Release contains a few major features that everybody talks about. For APEX 5.2 for example this will be Remote SQL Data Access, REST service consumption, the new REST workshop and improvements in the interactive grid.


In addition to this there will be certainly be almost 100 other smaller features and improvements delivered by the APEX team. The wizards will be improved, the PL/SQL and Javascript APIs will be enhanced and the plugin infrastructure will be extended.

Many of these features are certainly not talked about enough because they continually increase our productity or make things simply easier ... if and only if you are aware that they exist and how to use them.

In this presentation we will have a close look at the most noteworthy of the smaller new features. Certainly we will see hands on demos and the full demo application will be provided as a download."




Dimitri Gielis - Developing APEX apps in 2018 (Beginner)

Zaakvoerder – APEX R&D

ACE Director



"How we develop with Oracle Application Express evolved over time. We now need to take care of the mobile aspect, are in the Low code decennia, need to optimize our workflow as much as possible...

In 2017 I did a series of blog posts how I was building the mtable.online game in Oracle Application Express (APEX) and those posts I put in this presentation.

We will cover quickSql, Blueprint, APIs and other tips and tricks that can help you building modern applications."




Lidewij van den Brink - Dynamical OracleJET charts – interactive and compelling, but also complex (Beginner)

consultant BI/APEX - Transfer Solutions



In APEX 5.1, new and more sophisticated OracleJET charts were introduced to replace existing AnyChart Charts. The OracleJET package is provided with an extensive function overview with cookbook, but how can we make use of these settings and options in an APEX application? Since only a limited subset of OracleJET charts and settings is included into the APEX Chart plug-in and only a handful of APEX-specific OracleJET examples are present, the main challenge is how to use one of the many examples in the cookbook within APEX. This presentation shows a practical example application with OracleJET charts, in which the end-user can set, filter and format the charts to execute their own data-analysis. Special attention is given to SQL and PL/SQL functions that help to load, filter and show data dynamically in a single graph. Together with the necessary workarounds, this presentation will help you to get started with  OracleJET.




Roel Hartman - 3D - Docker for Database Developers


Director – APEX Consulting
ACE Director



"This session will briefly cover the Docker basics, but then we will dive in into the more intermediate use of Docker.
We will walk through the following subjects:
- What is Docker
- Images, containers and basic concepts
- Create and / or modify images
- Use Docker Compose to define multiple dependent containers
- Run multiple ORDS instances and a loadbalancer
- Use Docker Swarm
- Putting it all in the cloud"




Matt Mulvaney - Getting to Grips with the Interactive Grid API (Intermediate)

Senior Development Consultant – Explorer UK



"Learning more about the Interactive Grid API is the way to extend your knowledge about how the Interactive Grid works and perform some fancy tricks.

Those new to the API will be wondering what you use the API for, and how do you even start to use it?

This hands-on presentation is for developers of all abilities; from those new to Interactive Grid to those wishing to explore the more advanced features.

My presentation starts small; with only a handful of lines of code to demonstrate how the configuration is used. I’ll then build up gradually from performing basic feature configuration, through validations and then concluding on row based selection processing - and more.

Along the way, I’ll also be sharing some tricks and standard code Explorer use to simplify and enhance your Interactive Grids."




Menno Hoogendijk - Exploring the details of APEX sessions (Beginner)

Oracle APEX Developer – Qualogy



"A session is one of the main features of APEX. It established a stateful behavior across pages for each user. Usually we take a session for granted but knowing how sessions work in detail can be of great usage when debugging errors. How does APEX secure and validate a session and its items? We will see what happens between creation and destruction of a session and how you can interact with it.

There are some important differences when assigning a value to an item via Automatic Row Fetch, Computation, Source or Default value. We all struggle with these things from time to time. And what happens exactly when you submit a page for page processing?

Ever heard about a 32k limitation in APEX? We’ll go into detail to clear out the exact problem and how to deal with CLOBs.

APEX 5.0 and APEX 5.1 have introduced additional features like asynchronous page submits, rejoin session and session cloning. We’ll take a look at how these things works and what the possible consequences are for our applications.

This presentation will be of value for both beginners and experienced APEX developers."

  Menno Hoogendijk - Securing ORDS (intermediate)
Oracle APEX Developer – Qualogy


REST is the most popular way of exposing your (database) resources to external clients. If you are exposing a service to your clients, you need to make sure that access is protected. The goal is to authenticate clients and authorize each request. There are two options that we will explore: basic authentication and OAuth 2.0.

OAuth 2.0 is a standard Internet protocol that provides a means for HTTP servers providing REST APIs to give limited access to third-party applications on behalf of an end user.

A REST service is created inside a module. To protect it, we create a new privilege to allow clients with specific roles to use our module. ORDS provides all the PL/SQL packages we need and SQL Developer has a good user interface to do the setup.




Mirela Georegescu - Iframes – when necessity calls for them (Intermediate)

Consultant, APEX developer - Transfer Solutions



When a lot of information has to be shown on a page or when information needs to be available within a few clicks, iframes could be the solution. However, APEX does not offer out-of-the-box support for iframes. This presentation answers the questions of why, when and how to use iframes. Advice is given on which APEX components to use (and which cannot be used) in the APEX + iframes combination.





Moritz Klein - APEX APIs for Everyone 




"APEX itself delivers a wealth of functionality already out of the box and makes it very easy to use all those beauties declaratively in our applications.

Maybe you want to just slightly do it differently but can't directly from the Page Designer?

APEX is very well suited for this approach and with PL/SQL, the Oracle Database, HTML and Javascript you really have some mighty tools at your disposal.

But wait, did you ever take a good look at how APEX delivers this?

There are so many gems ""hidden"" in the APEX APIs, both PL/SQL and JS, you should really take a closer look.

Together we will do exactly that, dive into the APEX APIs and explore a rich world.

The closer you can stay to those APIs with your custom code the easier upgrades will get.

In addition, there is less chance to reinvent the wheel once you have a good understanding of all the is supplied.

Our exploration will be based on solutions from real customer projects and you will get some ready-to-run code for some common requests."





Niels de Bruijn - This is how we do it (Intermediate)

Business Unit Manager APEX – MT AG

ACE Director



"Each APEX project is different, but after 13 years doing APEX projects, we see certain patterns:

- in the way we work together in the team

- in the way we implement the application (automated/manual processes, using plugins, using a page generator for maintaining master data)

- in the way we interact with the customer (meetings, preview version)

- in the way we automate things (CI/CD, Jenkins, Subversion)

The objective in this presentation will be to share our extensive knowledge about how we do APEX projects."





Richard Martens & Kevin Rütten (Smart4Solutions) - Using RESTfull services and remote SQL from Apex 5.2 (intermediate)



Apex 5.2 offers the "remote SQL" feature, a way to use RESTfull services straight from APEX. The presentation will show how to consume RESTfull servcies using HTTP(s), GET, PUT and POST, not only to ORDS (remote SQL) enabled services, but also to mySQL or Postgress databases.




 Sergei Martens (Smart4Solutions) & Frank Jacobs (iTank) - Continuously Delivering APEX Applications (Intermediate) 



Everybody know that versioning and APEX is not the best match. Mainly because our application is stored in the database and not on the filesystem. Using tools as Jenkins, Git, Docker, Selenium (for automated testing), etc. I will show how continuous delivery of (a suite of) APEX applications can be established.