Alex Nuijten
allAPEX
Oosterhout, The Netherlands
Actions
Alex Nuijten is a director at allAPEX, a company specializing in Oracle database development with PL/SQL and Oracle Application Express (APEX).
Besides his consultancy work, he conducts training classes, mainly in APEX, SQL and PL/SQL. Alex has been a speaker at numerous international conferences, such as ODTUG, Oracle Open World, UKOUG, IOUG, OUGF, BGOUG, OGH APEX World and OBUG. For his presentations, Alex received several Best Speaker awards.
Alex has written many articles in Oracle-related magazines, and he regularly writes about Oracle Application Express and Oracle database development on his blog "Notes on Oracle" (nuijten.blogspot.com).
Alex is co-author of the book “Oracle APEX Best Practices” (Packt Publishers), “Real World SQL and PL/SQL” (Oracle Press) and "Modern Oracle Database Programming (Apress).
Because of his contributions to the Oracle community, Alex was awarded the Oracle ACE Director award in August 2010.
Links
Badges
Area of Expertise
Topics
To V or not to V? or.. using SQL Macros in APEX?
The V function has been around APEX as long as ... let's say very long and that's a long time. The V function allows you to reference item values from session state in your SQL statements. When calling V there would always be a price to pay.
With recent releases of the database there is a new way to do something similar; SQL Macro. With SQL Macro you can create parameterized views and this could be very interesting for APEX Developers.
In this session I will give you an overview of this new functionality and how you can use it in your APEX applications.
The Ultimate Useless Facts of Oracle Quiz
Everybody can, and should, participate in this Useless Facts of Oracle Quiz. The winner will be the one who gets the most consecutive answers correct. There can be several rounds as time permits. End of the day, something to wind down with. schedule about 20-30 minutes for it.
SQL Assertions: The Greatest Database Feature You've Never Used
You implemented primary and foreign keys in your database, sprinkled with unique and check constraints, all to keep your data in the best shape possible.
But what about data-rules that involves multiple tables, apart from referential integrity?
For example: the total amount of the order must be the sum of the related order lines. How can you guarantee that this rule is always true?
Changing amounts at order line level will impact this rule, as well as changing the order total amount.
Lots of database developers will try to implement a watertight solution with triggers while working their way around mutating table issues.
You wish there was something simple ... and there is: SQL Assertions.
SQL Assertions have been around since the early 1990's - at least on paper.
Until now there was no database vendor that actually implemented SQL Assertions. Oracle is the first vendor that has cracked the code and implemented SQL Assertions in Oracle Database 23ai.
This session will show all aspects of SQL Assertions, with many real world examples.
Regular Expressions: Say What?
It has been possible since Oracle database release 10, Regular Expression support with its own set of functions. But getting started with Regular Expressions is not easy. Most database developers would avoid them if at all possible.
With current release of the Oracle database, Regular Expression syntax becomes more important. You can use them to redact data with DBMS_REDACT and to search for patterns using the Match_Recognize clause.
This session covers the basic syntax and gives you an easy introduction with Regular Expressions with plenty of code samples.
JSON takes the Database
As a lightweight data transfer format, JSON is increasingly popular. If fact it is the de facto standard for document exchange. Sending and receiving JSON documents from and to your database is becoming more and more common. Knowing what the Oracle database has to offer in terms of storage, querying JSON in SQL, processing in PL/SQL needs to be in the toolkit of every Oracle database developer.
This session focusses on the most important features that the Oracle database has to offer in the JSON arena.
The titel references the horror movie: Jason takes Manhattan, but I assure you this session is far from scary.
JSON path expressions: the path to power
JSON is the de facto standard as a data exchange format. More and more functionality is added with each release of the Oracle Database in the JSON realm. A key factor with most of these functions, is mastering path expressions. Path expressions allow you to filter out relevant data from the JSON document for processing.
But they offer so much more, like wildcard searches, conditional filtering, aggregation- and a lot more.
This session focuses on JSON Path expressions to boost productivity.
Lots of facets and caveats of path expressions are discussed with loads of code samples.
For your Eyes Only: APEX and VPD
Keeping data private can be quite a challenge. Of course it is easy enough to add predicates to your reports. But how do you handle data entry? You'll want to prevent users from adding data that is visible to other users. The same holds true for changing and removing data.
Implementing this level of security can be handled by the application, but we all know this is not the way to do it. What if the user downloads SQLcl or SQLDeveloper and sets up a connection to the database? What if we want to expose part of the data as REST Services?
Taking advantage of Virtual Private Database might just be what you're looking for.
Even though VPD is nothing new, implementing it correctly might be a challenge.
This session will explain the basic concepts and go over a detailed example of how to integrate VPD with APEX.
APEX, ORDS and JRDV - The Three Amigos
Oracle Database 23ai introduced JRDV: JSON -Relational Duality Views. This ground-breaking functionality give you the flexibiilty of JSON documents as well as all the advantages of the relational model.
A customer uses one centralised APEX Monitoring application to keep an eye on multiple satellite installations of APEX applications for different customers. Runtime data of these APEX applications are sent from the satellites to the Monitoring application using PL/SQL functions to code and decode the data and ORDS as the bridge in between.
Taking this real life project as a starting point we will demonstrate how the use of JSON-Relation Duality Views can have a huge impact on the complexity - and therefore maintainability - of the codebase.
Cookie Cutter APEX Applications
In a perfect world your APEX SAAS solution would be deployed with a click of a button, have a separate database for each customer, and can a customer choose when they want to upgrade to the next version. In this perfect world, the customer don't have to worry about default lookup data, because the SAAS provider does that.
This perfect world can be created with Application Containers and Oracle APEX. In this session you will learn the basics of Application Containers, how data is shared and separated in each container and how a new version is rolled out.
APEX and Spatial: Finding the most delicious Apple Pie
I love Apple Pie, especially when it's a little bit warm and there are big chunks of apple and a nice cinnamon flavour.. yum!
But where did we stop last time for applepie? Was it any good? Should we go to this place again or should we avoid it?
Where is the closest restaurant which serves the best apple pie?
All these - very important - questions can be answered with an APEX app.
The Oracle database has a lot of built-in Spatial functionality, like finding nearby locations or calculating distances. With APEX it is very easy to incorporate Maps into your applications and find your current location. This session introduces you to both so you can take advantage of Spatial functionality in your own APEX applications.
Analytic Functions: Unleash the SQL Power
Analytic Functions have been around for quite a long time, and still they are a relatively unknown. If you are unfamiliar with these very powerful functions, you are missing out on something spectacular. Analytic Functions add inter-row calculations, aggregates over multiple dimensions, or rank assignment based on values within a group of values - all without a GROUP BY clause.
The syntax might seem daunting at first, but it is really not that scary. This session will focus on the syntax with tons of real world uses for Analytic Functions.
HrOUG 2025 Sessionize Event Upcoming
MakeIT 2025 / JCON OpenBlend Slovenia 2025 Sessionize Event
ITOUG Tech Day 2025 Sessionize Event
OUGN2025 Sessionize Event
HrOUG 2024 Sessionize Event
MakeIT 2024 / JCON OpenBlend Slovenia 2024 Sessionize Event
ConTech2024 by RoOUG Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top