APEX Connect and Kscope17

A sneak preview of my presentations at APEX Connect and Kscope17

Published on: Category: Oracle

This year I’m going to APEX Connect in Berlin (May 9 – 11) and Kscope17 in San Antonio (June 25-29). At both events I will hold several presentations. I feel honored to be part of this and I’d love to tell you more about it!

1. RequireJS in Apex 5.1 (Apex Connect, Berlin)

Date: Tuesday May 9
Time: 4:15 PM - 5:00 PM
Location: Soul room

My first presentation will be held at APEX Connect in Berlin and is all about RequireJS in APEX 5.1. Oracle Jet uses RequireJS, which is shipped in APEX 5.1. What makes this so cool is that we can take advantage of it too! 

RequireJS is a JavaScript file and module loader that enables you to write modular and reusable code. In the first part of the presentation, I'll explain the philosophy and advantages of RequireJS and modular JavaScript. Things like defines, requires, AMD and shims may not ring a bell yet, but if you attend the presentation, you’ll learn all about them.

The second part is all about demos and showing how they’re best used in an APEX application. It's very powerful when combined with APEX plugins. For advanced usage, we’ll take a look at the optimizer – a tool that concatenates and minifies individual JavaScript files into one big bundle.

This presentation will give you a solid introduction to RequireJS. All demos and code will be made publicly available.

2. Automating developer tasks with custom SQLcl scripts (APEX Connect, Berlin)

Date: Thursday May 11
Time: 12:00 PM - 12:45 PM
Location: Soul room

The second presentation at APEX Connect delves deeper into the automation of developer tasks with custom SQcl scripts.

I recently discovered the power of SQLcl, the successor to SQL*Plus. In addition to offering a range of functionalities, from managing ORDS modules to exporting APEX applications, it also allows us to create custom commands.

You can write your own script in JavaScript, a language most of us are (somewhat) familiar with. SQLcl uses Nashorn, an Oracle JavaScript engine built in Java. You can build a script for practically anything that involves the database and APEX. It's all about automating cumbersome tasks.

I created a deployment script for installing database objects, which checks several things, such as:

  • the format of the SQL files
  • the version number of the files (equal or higher than the object in the target database)

SQLcl is not yet well-documented and building a script can be quite challenging. 

During this presentation, I will explain and demonstrate the features of Nashorn and show you how to configure SQLcl!

Looking forward to my presentations

3. Plugin your APEX widgets (Kscope17, San Antonio)

Date: Wednesday June 28
Time: 09:45 AM - 10:45 PM 
Location: Iris / Lily

At Kscope, I will host a session on APEX widgets. APEX 5.1 includes a lot of jQuery widgets and plugins under the hood. Since the development team uses them to create beloved components like the Interactive Report and Interactive grid, why not use the technique ourselves?

This session will demonstrate why widgets and plugins are so powerful. Did you know they can be exposed as APEX plugins for declarative reuse? We'll explore how some of the existing widgets work in order to build our own, step by step.

Building widgets
I've been building these plugins and widgets for some time now. They are used heavily in APEX because they are a perfect fit. We will learn about:

the difference between a plugin and widget

  • where it's used in APEX
  • using widgets from the jQuery UI core inventory
  • creating a jQuery plugin
  • creating and extending a widget
  • using the plugin as part of the widget
  • exposing it in APEX as an APEX plugin

As you can see, the focus will not be on building APEX Plugins, but on the underlying technique. I’d like to achieve the following goals:

  • provide the techniques to create these independent, reusable components and explaining the advantages of this approach
  • remove any worries about it

4. Powerful JavaScript skills for all APEX developers (Kscope17, San Antonio)

Date: Tuesday June 27
Time: 11:15 AM - 12:15 PM 
Location: Cibolo Canyon 5

Are you a developer looking for steady JavaScript skills? We all have to deal with the same issues sooner or later. Knowing about the most common features will help you solve issues and create advanced applications. We'll go over a range of topics, such as:

  • fundamentals
  • bad practices
  • improvements and new features

The result:  professional, organized code! This session is intended for beginners and intermediate developers. Join my class and gain a better understanding of the ever-changing JavaScript landscape.

Understand the concepts
My fellow developers have expressed considerable interest in a session on JavaScript skills specific to APEX. This is particularly true of developers with a background in SQL/ PL/SQL. This session will help them understand the concepts covered in the more advanced sessions. 

I'll dive right in from the start, with most slides functioning as a live demo. The demos will be simple and will focus on solving real-life problems. Of course, you’ll be able to have a go at the materials yourself after the session. You’ll learn more about:

  • DOM
  • jQuery
  • Design Patterns
  • Common functionality 
  • Callbacks & promises
  • Plugins & widgets
  • ES6 improvements
  • the ever-changing JavaScript landscape

In addition to covering jQuery, we’ll also cover a lot of plain JavaScript too.

More information

See for more information: Apex Connect and Kscope17.


Menno Hoogendijk
About the author Menno Hoogendijk

I work as an Oracle APEX Consultant at Qualogy since november 2016. I develop APEX-applications, translate user experiences into technology and support colleagues. I like to create solutions for our customers and want to learn something new every day!

More posts by Menno Hoogendijk