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)
- 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
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.
Alan Arentsen - Closing the gap between APEX and JET (Intermediate)
APEX Developer - Arentsen Database Consultancy
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
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
- 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
- Visibility (Search Engine Optimization)
- 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.
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
"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
"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?
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
"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.