Oracle Database
Oracle Database has been the foundation of my work for more than two decades.
Long before cloud platforms, low-code development and generative AI became part of my daily work, I was building business applications around data, SQL and PL/SQL.
That database-first perspective still strongly influences how I design applications today.
Database-driven applications
I believe that in data-intensive business applications, the database should do much more than simply store data.
My work with Oracle Database includes:
- SQL and PL/SQL development
- data modelling
- business logic
- background processing
- integrations
- security
- performance
- data-intensive enterprise applications
Over the years, I have used these capabilities to build and modernize business systems where reliability, clarity and maintainability matter more than unnecessary technological complexity.
SQL & PL/SQL
SQL and PL/SQL remain essential tools in my daily work.
Even as development tools evolve, keeping appropriate business logic close to the data can provide a simple and powerful architecture for enterprise applications.
The database is often where important business rules, validations, calculations and integration logic ultimately come together.
Selected Oracle Database articles
How to Generate a Database User Password with Special Characters
A practical PL/SQL solution for generating database passwords that contain special characters while satisfying common password requirements.
Calling PL/SQL from JavaScript in Oracle APEX with AJAX
A practical example of how browser-side JavaScript and server-side PL/SQL can work together in an Oracle APEX application without submitting the entire page.
Although this is an APEX example, the server-side logic remains firmly rooted in PL/SQL and Oracle Database.
Database and APEX
Oracle APEX became a natural extension of this database-centric approach.
Instead of introducing a completely separate application stack, APEX made it possible to build web applications directly around:
- Oracle Database
- SQL
- PL/SQL
- database security
- existing business logic
This relationship between the database and the application layer is one of the main reasons APEX became such an important part of my work.
If you are interested in the application layer, continue with:
Database and integration
Enterprise systems rarely exist in isolation.
Over the years, database development has increasingly included integration between applications, services and external systems.
One example is REST Enabled SQL.
Connecting Oracle APEX Applications with REST Enabled SQL
This case study shows how separate Oracle APEX applications can work with shared business data through REST Enabled SQL while keeping systems and responsibilities separated.
For me, integration is not primarily about adding another technology.
It is about allowing business systems to exchange data safely and predictably.
From traditional infrastructure to Autonomous Database
My Oracle Database work eventually led naturally into Oracle Cloud and Autonomous Database.
The fundamental concepts did not disappear:
- schemas
- SQL
- PL/SQL
- data models
- security
- transactions
But the infrastructure around them changed significantly.
I documented that transition in:
My Journey to Oracle Cloud
A series about moving from traditional Oracle infrastructure toward OCI and Autonomous Database, including the decisions, migration steps and lessons learned along the way.
Database and AI
AI is creating another major shift in how we interact with enterprise data.
For me, one of the most interesting developments is that users no longer always need to think in terms of SQL.
They can increasingly ask questions in natural language while the database remains the trusted source of business information.
Testing Oracle Select AI Capabilities
My early practical experiments with Oracle Select AI and natural-language access to enterprise data.
Generative AI with Your Own Data and Documents
A later experiment combining Oracle Select AI, RAG, AI agents, SQL tools and company documents.
These experiments reinforced an important idea for me:
AI does not make the database less important.
In enterprise systems, it may make trusted, well-structured data even more valuable.
The database remains the source of truth
Generative AI can provide a new interface to information.
Oracle APEX can provide the application layer.
Cloud can provide infrastructure and AI services.
But enterprise systems still need a reliable source of truth.
That means understanding:
- where the data lives
- what it means
- how it is related
- who can access it
- which rules protect its consistency
Those are still database questions.
The foundation of the journey
My work has gradually expanded through several layers:
Database → APEX → Cloud → AI
Each new layer has added new possibilities.
But the database remains the foundation underneath them.
For me, good enterprise software still starts with well-structured data and a solid understanding of the business processes behind it.