Roel Hartman
APEX Consulting
Deventer, The Netherlands
Actions
Roel started a long time ago using Oracle RDBMS 5, Oracle Forms 2.3, RPT/RPF and Oracle*Case 4.5. Since over 10 years he focuses mainly on Oracle Application Express.
Roel has been a speaker on UKOUG, OOW, Collaborate, ODTUG's Kscope and a number of local Oracle User Groups.
Within ODTUG he acted as the APEX Content Lead for the Kscope14 and KScope15 conferences and was a member of the Board of Directors from 2018 to 2024.
He keeps an (APEX-related) blog on https://roelhartman.blogspot.com.
In June 2009 Roel received an Oracle ACE award and in August 2010 he's appointed as Oracle ACE Director.
Roel is a co-writer of the "Expert Oracle Application Express" and "Oracle Application Express for Mobile Web Applications" books.
Roel is Director at APEX Consulting in The Netherlands.
Badges
Area of Expertise
Topics
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.
APEXLang: Bridging Legacy and Modern - AI-Powered Code Generation for Oracle APEX
Discover how APEXLang is revolutionizing Oracle APEX development by combining the power of large language models with Model Context Protocol (MCP) servers.
This session explores three transformative use cases: rapidly scaffolding new APEX applications through natural language specifications, intelligently enhancing existing applications with automated code generation, and dramatically accelerating legacy-to-APEX migrations—particularly from Oracle Forms.
We'll demonstrate how APEXLang leverages MCP servers to provide rich contextual awareness of your APEX environment, database schemas, and existing codebase, enabling more accurate and context-aware code generation. You'll see if it can convert Oracle Forms pages including triggers and PL/SQL logic into modern APEX components, extending applications with new features through simple prompts, and maintaining consistency across development teams.
Whether you're facing a daunting Forms migration, looking to accelerate APEX development, or exploring ways to modernize your development workflow, this session will show you how APEXLang and MCP servers can become your most productive development partner.
Anatomy of an APEX Page
What happens when an Oracle APEX page loads? What occurs behind the scenes when a user clicks a button? Understanding the anatomy of an APEX page—its internal structure and execution flow—is the key to unlocking the platform's full potential and prevents you from making mistakes.
This presentation dissects the fundamental architecture that brings APEX pages to life. We'll trace the complete lifecycle of a page: from rendering, through user interactions that trigger actions, to validations and processes that execute your business logic, and branches that control navigation flow. Discover how session state acts as the central nervous system, maintaining context and data throughout the whole lifecycle.
Whether you're deepening your APEX expertise or exploring what makes this rapid development platform so powerful, this session provides the foundational knowledge that separates good APEX developers from great ones. Come explore the anatomy that makes every APEX page work.
HrOUG 2025 Sessionize Event
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