A sneak preview of my presentations at APEX Connect and Kscope17Published on: Author: Menno Hoogendijk 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!
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.
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!
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.
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
Date: Tuesday June 27
Time: 11:15 AM - 12:15 PM
Location: Cibolo Canyon 5
- bad practices
- improvements and new features
Understand the concepts
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:
- Design Patterns
- Common functionality
- Callbacks & promises
- Plugins & widgets
- ES6 improvements