Jon Dixon
@jon.cloudnueva.com
📤 707
📥 417
📝 333
♠️ Oracle ACE Pro. APEX, ORDS, DB, OCI. Writing at
http://blog.cloudnueva.com
#orclAPEX
Please read my latest post on the importance of using ➡️ Database Views in APEX ⬅️
#orclAPEX
blog.cloudnueva.com/importance-o...
loading . . .
Utilizing Views in APEX: Key Benefits
Discover the important role of database views in APEX development, enhancing reusability, security, data consistency, and application maintenance
https://blog.cloudnueva.com/importance-of-using-views-in-apex
6 days ago
0
4
1
reposted by
Jon Dixon
nlOUG
9 days ago
Do not forget to submit your abstract for APEX World 2025, just 2 more weeks to go before the call for papers closes on December 1st. Go to
apexworld.nloug.nl
to submit your abstract
#APEXWorld
#cfp
#orclAPEX
#AW26
0
4
3
reposted by
Jon Dixon
Jeff Smith
20 days ago
FreeSQL.com
now supports SQLNet connectivity for your free schema on both our 19c and 26ai database platforms.
loading . . .
https://FreeSQL.com
3
9
7
reposted by
Jon Dixon
Connor McDonald on Database and SQL
20 days ago
Fresh post! Watch your JSON fly!
connor-mcdonald.com/2025/11/06/t...
loading . . .
Turbo boost your LOBs and JSON
Go back a few decades before XML and JSON and you could easily categorise data into (roughly) two categories: small data, like names, addresses, descriptions, numbers, dates, etc big data, like doc…
https://connor-mcdonald.com/2025/11/06/turbo-boost-your-lobs-and-json/
0
2
2
Do you need to display 🎨 colored icons in an APEX 🌲 Tree Region? It's not as straightforward as you may think 🤔. Please read my post to find out how to do it.
#orclAPEX
blog.cloudnueva.com/color-icons-...
loading . . .
Color-Coded Nodes in APEX Tree
Learn to assign different colored icons to nodes in an APEX Tree Region to easily identify hierarchy changes
https://blog.cloudnueva.com/color-icons-in-apex-tree-regions
20 days ago
0
3
2
reposted by
Jon Dixon
Niels de Bruijn
about 1 month ago
Call for Papers for APEX connect 2026 18-20 May in Heidepark has started! This is your chance to share your experience about what you have been building using Oracle APEX, SQL and/or PL/SQL! CfP ends on 2-DEC EOD.
apex.doag.org/en/home/
#orclapex
0
7
4
reposted by
Jon Dixon
Roel
about 1 month ago
Who doesn't want to be part of the 16th edition of APEX World? Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between. 👉 Visit
buff.ly/dJc3ogC
to submit your abstract! Open until Dec 1
0
6
5
reposted by
Jon Dixon
Alex Nuijten
about 1 month ago
Had it scheduled to be published but forgot to make noise about it 🤦♂️
#JoelKallmanDay
nuijten.blogspot.com/2025/10/add-...
loading . . .
Add a Little Joy to your Buttons #JoelKallmanDay
Recently we were sitting outside at a café having a coffee and a slice of apple pie, something we do often. This is nothing remarkable, b...
https://nuijten.blogspot.com/2025/10/add-little-joy-to-your-buttons.html?m=1
0
5
2
reposted by
Jon Dixon
Sandra Suarez
about 1 month ago
To commemorate
#JoelKallmanDay
, I deep dive into the why and how of company-wide systems assessments. Because we can’t modernize what we don’t understand. A smarter ERP starts with a clearer system landscape.
#JoelKallmanDay
#orclAPEX
#OracleERP
sandra-suarez.com/why-a-system...
loading . . .
Why a Systems Assessment Can Make or Break Your ERP
A smarter ERP starts with a clearer system landscape. You can’t modernize what you don’t understand.
https://sandra-suarez.com/why-a-systems-assessment-can-make-or-break-your-erp-joelkallmanday?showSharer=true
0
8
3
#JoelKallmanDay
add a skeleton here at some point
about 1 month ago
0
12
2
Please read my latest post, where I explore how the Oracle SQLcl MCP Server can help you build higher-quality APEX Apps more quickly.
#orclAPEX
#mcp
#sqlcl
blog.cloudnueva.com/oracle-sqlcl...
loading . . .
Oracle SQLcl MCP Server Setup and Usage
Deep dive into how the Oracle SQLcl MCP Server and your preferred development tool can help you build higher-quality software more quickly.
https://blog.cloudnueva.com/oracle-sqlcl-mcp-server-with-codex-and-copilot-joelkallmanday
about 1 month ago
1
7
2
reposted by
Jon Dixon
Tim Hall
about 1 month ago
Oracle AI Database 26ai Free available for download.
www.oracle.com/database/fre...
I've done my first install.
4
13
4
What could go wrong?
#orclAPEX
about 2 months ago
1
3
0
reposted by
Jon Dixon
Oracle ACE Program
about 2 months ago
Exciting news! ✨ Oracle ACE Louis Moreaux will be sharing his expertise at the APEX SPECIAL SERIES 2025 on October 9. Don’t miss this opportunity to learn from top experts in the Oracle APEX community! Explore the event details and register: 🔗
ausoug.org.au/apex-special-series-2025
#OracleACE
0
4
1
Learn how to ✅ Handle non-standard REST API Authentication Schemes in APEX & ✅ continue to use APEX Web Credentials in REST Data Sources and APEX_WEB_SERVICE.
#orclAPEX
blog.cloudnueva.com/handle-non-s...
loading . . .
Handle Non-Standard API Authentication in APEX
Learn how to securely handle non-standard API authentication in Oracle APEX by storing credentials with TDE and Data Redaction, using APEX Web Credentials.
https://blog.cloudnueva.com/handle-non-standard-api-authentication-in-apex
about 2 months ago
0
1
0
reposted by
Jon Dixon
Connor McDonald on Database and SQL
2 months ago
Coming to AI World? Over the next few days, I'll post my picks for cool Database and APEX content. Or just come hang out at the Database booth :-)
connor-mcdonald.com/2025/09/26/m...
loading . . .
My Session Picks for AI World – Tuesday
Tuesday is when things really ramp up at AI World, so hopefully you have brought a few work friends with you, because there is a lot over overlapping content that will interest fellow Database and …
https://connor-mcdonald.com/2025/09/26/my-session-picks-for-ai-world-tuesday/
0
2
1
reposted by
Jon Dixon
Tim Hall
2 months ago
Joel Kallman Day 2025 : Announcement
oracle-base.com/blog/2025/09...
#JoelKallmanDay
@oracleace @OracleAPEX
#orclapex
@OracleDatabase
1
20
18
Happy to hear that I have two presentations accepted for 🇬🇧 UKOUG.
#orclAPEX
2 months ago
1
9
0
reposted by
Jon Dixon
ODTUG
2 months ago
INSIDE SCOOP: The
#Kscope26
Call for Abstracts is slated to open early next week! Submitters will find new opportunities in the OCI and AI spaces, plus longer session times (meaning, no more 30 minute sessions). Keep an eye on ODTUG socials and email for updates!
www.odtug.com/kscope26
0
3
1
reposted by
Jon Dixon
Connor McDonald on Database and SQL
2 months ago
Fresh video! The best thing about JSON is its flexibility...and the worst thing about JSON might also be its flexibility. How do you ensure your JSON data matches your business rules? 23ai can help!
youtu.be/5wQqKUCQlxg
loading . . .
Is your JSON filled with garbage?
YouTube video by SQL and Database explained!
https://youtu.be/5wQqKUCQlxg
0
3
1
reposted by
Jon Dixon
Anders Swanson
3 months ago
Transactional Outbox: Simplified with Oracle Database Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional…
loading . . .
Transactional Outbox: Simplified with Oracle Database
Event streaming is extremely popular in modern application architectures, providing high-throughput, real-time data flow in microservices architectures. However, ensuring data consistency in distributed systems is challenging — Traditional two-phase commit (2PC) implementations can be costly and slow, making them impractical for high-throughput environments. In this article, we’ll solve data consistency challenges in event streaming systems using Oracle Database Transactional Event Queues…
https://andersswanson.dev/2025/09/12/transactional-outbox-simplified-with-oracle-database/
0
6
2
@connormcd.bsky.social
I see what you did. 100% sorts to the top of the AI World schedule.
3 months ago
2
4
0
Learn why it's a good idea to wrap APEX_MAIL with your own API ➕➕ Find out why JSON_OBJECT_T provides ultimate flexibility when passing values between PL/SQL procedures.
#orclAPEX
blog.cloudnueva.com/wrapping-ape...
loading . . .
Wrapping APEX_MAIL & Using JSON_OBJECT_T for Placeholders
Learn how to wrap APEX_MAIL with a PL/SQL API and use JSON_OBJECT_T for efficient email placeholder management.
https://blog.cloudnueva.com/wrapping-apexmail-and-placeholders
3 months ago
0
6
0
reposted by
Jon Dixon
nlOUG
3 months ago
* SAVE * THE * DATE * Mark your calendars! On Nov 13th, join us for a day packed with Database, Cloud, and Developer excitement. Esteemed speakers from across the
#EMEA
region will be participating. Check out more details at
nloug.nl/events/najaa...
.
#orclAPEX
#oracle
#DC&D2025
0
7
9
reposted by
Jon Dixon
Connor McDonald on Database and SQL
3 months ago
Your 19c autonomous database can now be upgraded to 23ai with just a click!
www.linkedin.com/pulse/autono...
loading . . .
Autonomous Database in-place uprgade to 23ai now available
GREAT NEWS! You can now perform an in-place upgrade on 19c databases to 23ai. We have made the process really easy by giving you two simple options to schedule the upgrade: (1) Earliest available sche...
https://www.linkedin.com/pulse/autonomous-database-in-place-uprgade-23ai-now-available-keith-laker-dy2ce
1
5
1
Excellent thanks for sharing. Very funny.
add a skeleton here at some point
3 months ago
0
2
0
reposted by
Jon Dixon
Philipp Hartenfeller
4 months ago
Use AI without data leaving your network. How to integrate the open GPT models from
#OpenAI
into an
#orclAPEX
app with
#Ollama
and
#ucAI
:
hartenfeller.dev/blog/open-an...
loading . . .
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
https://hartenfeller.dev/blog/open-and-local-AI-models-in-oracle
0
5
2
There does not seem to be a correlation between the model in the Copilot chat and the model used by the Oracle SQLcl MCP server. Is there a way to choose the model for the Oracle SQLcl MCP server?
@thatjeffsmith.com
4 months ago
1
1
1
I am happy today. Touch ID magically started working again on my Magic Keyboard. 😀
4 months ago
0
1
0
reposted by
Jon Dixon
Philipp Hartenfeller
4 months ago
OpenAI just announced open models. Perfect timing, you can use them today from PL/SQL with UC AI and Ollama.
openai.com/open-models/
#orclAPEX
#ucai
#plsql
#oracle
add a skeleton here at some point
1
4
2
reposted by
Jon Dixon
Philipp Hartenfeller
4 months ago
UC AI v25.4 is live 🥳. New features: - Reasoning: Let AI think about your problems - Ollama: New provider that allow you to run models >>locally<<
#oracle
#AI
#orclAPEX
#ucAI
More here:
www.united-codes.com/products/uc-...
loading . . .
Release History
A comprehensive list of all releases of UC AI
https://www.united-codes.com/products/uc-ai/docs/other/relase-history/
1
6
3
reposted by
Jon Dixon
Tim Hall
4 months ago
You don’t have to wait for 23ai for these features!
oracle-base.com/blog/2025/08...
@OracleDatabase
#database
#19c
2
11
4
🚨 Is your Oracle APEX stack aging quietly? Years can pass with no issues until the hidden technical debt snowballs. I break down the silent risks, remediation strategies, and real-world lessons from migrating an APEX 18.2 app to OCI.
blog.cloudnueva.com/is-your-apex...
#orclAPEX
loading . . .
Is Your APEX Environment Aging Quietly
Oracle APEX apps run for years. Silent technical debt adds up. Learn how to assess & remediate aging apps to boost speed, security, & maintainability.
https://blog.cloudnueva.com/is-your-apex-environment-aging-quietly
4 months ago
0
7
2
reposted by
Jon Dixon
SQLDaily
4 months ago
Tell
#SQL
stories with SQL Notebooks in Oracle SQL Developer for VS Code Show statements with their results Along with markdown blocks to describe the data
@thatjeffsmith.com
shows
loading . . .
SQL Notebooks in Oracle SQL Developer for VS Code
Introducing SQL Notebooks, a new way to work with Oracle Database SQL and PL/SQL scripts in the SQL Developer Extension for VS Code.
https://buff.ly/NXOF3Dt
0
4
2
Proof (if any were needed) that AI function calling is more popular than testing/evals 🤦
4 months ago
0
0
0
reposted by
Jon Dixon
Joel Acha
4 months ago
🚀 Just published: “Fusion Data Intelligence Under the Hood” Explore how Oracle FDI unifies Fusion SaaS, ADW, OAC & AI into a secure, scalable Data Intelligence Platform. Read the blog ➡️
www.elffar.co.uk/blog/fusion-...
#OracleAnalytics
#FDI
#analytics
#ADW
loading . . .
Fusion Data Intelligence Under the Hood: A Deep Dive into the Architecture
In the previous post , we traced how Fusion Data Intelligence (FDI) evolved from OBIA. In this second instalment of our FDI‑introductory series, you’ll explore the underlying technology and...
https://www.elffar.co.uk/blog/fusion-data-intelligence-under-the-hood-a-deep-dive-into-the-architecture
0
2
1
reposted by
Jon Dixon
Kai Donato
4 months ago
Neue
@devsontape.bsky.social
-Folge 🎙️: Markus Peppler zeigt, wie > 70
#orclapex-Apps
täglich 1 000+ User begeistern , warum strenge Governance kein Innovationskiller ist und wie
#KI
trotzdem
#on-prem
klappt. 🎧 Hör rein:
on.devsontape.com/mpe
#FinTech
#Podcast
#oracleace
@oracleace.bsky.social
0
5
1
reposted by
Jon Dixon
Philipp Hartenfeller
4 months ago
New blog post: ✅ What is the
#SQLcl
#MCP
server ✅ How does it work under the hood ✅ Security concerns ✅ Tools vs. MCP
hartenfeller.dev/blog/demysti...
#oracle
#orclAPEX
loading . . .
Demystifying the SQLcl MCP Server
A deep dive into Oracle's SQLcl MCP Server: understanding its capabilities, testing its tools, and examining the security implications for database access through AI.
https://hartenfeller.dev/blog/demystifying-sqlcl-mcp-server
1
11
5
Learn how you can use OpenAI’s function calling with PL/SQL in your APEX apps today. ✅ Skip the RAG overload ✅ Let LLMs ask for just the data they need ✅ Keep your logic & data secure in the DB
blog.cloudnueva.com/ai-function-...
#orclAPEX
#LLM
#OpenAI
#functioncalling
loading . . .
AI Functions and Oracle APEX
Integrate AI function calling in APEX for efficient data retrieval, secure interactions, and enhanced business logic with custom tools.
https://blog.cloudnueva.com/ai-function-calling-with-apex
4 months ago
0
2
0
reposted by
Jon Dixon
Matt Mulvaney
5 months ago
🚀 New Blog for
#orclapex
Learn how to extract every part of an Oracle APEX URL in JavaScript. Supports classic & friendly URLs, parameters, and more. Check it out:
mattmulvaney.hashnode.dev/extracting-e...
1
5
1
reposted by
Jon Dixon
Oren Nakdimon
5 months ago
A new post (about an old feature) - "Mixed Feelings About MERGE"
db-oriented.com/2025/07/12/m...
@oracleace.bsky.social
#ACED
@sym42.bsky.social
loading . . .
Mixed Feelings About MERGE - @DBoriented
Why Oracle's MERGE Statement Fails Where INSERT/UPDATE Succeeds
https://db-oriented.com/2025/07/12/mixed-feelings-about-merge/
1
8
2
reposted by
Jon Dixon
Philipp Salvisberg
5 months ago
Do your outer join queries produce more rows than expected? In this blog post, I show a strange result when using filter predicates in the join clause. dbLinter can help you sort your join and filter criteria and spot issues like this.
www.salvis.com/blog/2025/07...
loading . . .
Outer Joining With ANSI SQL-89 and SQL-92
Introduction I recently implemented a quick fix for the rule G-3130 to transform queries to ANSI SQL-92 syntax. One of the challenges was to handle Oracle’s outer-join syntax (+). In ANSI SQL-89, join...
https://www.salvis.com/blog/2025/07/12/outer-joining-with-ansi-sql-89-and-sql-92/
0
8
8
I found this super interesting. I think some of it is related to learning a new way of working. Some of it is just that we are not good at estimating! Worth a read
metr.org/blog/2025-07...
loading . . .
Measuring the Impact of Early-2025 AI on Experienced Open-Source Developer Productivity
We conduct a randomized controlled trial to understand how early-2025 AI tools affect the productivity of experienced open-source developers working on their own repositories. Surprisingly, we find th...
https://metr.org/blog/2025-07-10-early-2025-ai-experienced-os-dev-study/
5 months ago
0
2
0
Discover why evaluations or "Evals" are crucial in AI development and how to implement them in your Oracle APEX AI solutions.
#evals
#orclAPEX
blog.cloudnueva.com/why-evals-ar...
loading . . .
The Importance of AI Evaluations
Discover why Evals are crucial in AI development, and how to implement them in your Oracle APEX AI solutions
https://blog.cloudnueva.com/why-evals-are-important-in-ai-development
5 months ago
0
8
1
🥳 Playing with the brand new MCP server for Oracle SQLcl, running from VS Code.
5 months ago
0
3
1
💯 The results are in for last week's APEX Developer Blogs' Ask the Community' question. Universal Theme CSS classes just pipped to the post by Custom CSS. Check out this week's question on your favorite APEX Printing tool.
#orclAPEX
apps.cloudnueva.com/apexblogs
5 months ago
0
4
0
Discover how to reduce the cost and complexity of archival solutions using Oracle APEX and OCI.
#orclAPEX
#OCI
blog.cloudnueva.com/two-archival...
loading . . .
Building Cost Effective Archive Solutions with APEX
Read this post to discover how you can reduce cost and complexity of archival solutions using Oracle APEX and OCI.
https://blog.cloudnueva.com/two-archival-solutions-built-on-apex
5 months ago
0
4
0
reposted by
Jon Dixon
Philipp Hartenfeller
5 months ago
Introducing UC AI 🪄: ✅ open source ✅ tools/function calling: AI calls your PL/SQL functions ✅ multiple providers: OpenAI, Claude, Gemini ✅ unified API Use this to build smart
#orclapex
applications/automation directly from PL/SQL
youtu.be/0Pzi994RRtM
#oracle
#ai
loading . . .
Let AI safely run functions in the database | UC AI
YouTube video by United Codes
https://youtu.be/0Pzi994RRtM
3
14
3
reposted by
Jon Dixon
Jeff Smith
5 months ago
New post! PARs are easier to manage in ORDS now, and a quick note for the
#orclapex
community
www.thatjeffsmith.com/archive/2025...
loading . . .
More on PARs and a note re: APEX RESTful Data Services
ORDS version 25.2 is now available! Also a quick overview on the new PAR support in SQL Developer Web and a note regarding RESTful Services interface in APEX.
https://www.thatjeffsmith.com/archive/2025/07/more-on-pars-and-a-note-re-apex-restful-data-services/
0
4
3
reposted by
Jon Dixon
Philipp Hartenfeller
5 months ago
This Wednesday, I'll be sharing something really cool on the United Codes YouTube channel. You won't want to miss it!
#orclAPEX
0
9
4
Load more
feeds!
log in