Dan McGhan
@dmcghan.bsky.social
Software Development Engineer at Oracle. ❤️ Oracle Application Express (APEX), Oracle Database, CI/CD & JavaScript. Views are my own, not Oracle's.
Reposted by Dan McGhan
I had the privilege to present about CI/CD and relational databases during #Thementage25 (www.ittage.informatik-aktuell.de/thementage.h...) I promised I'd polish my demo and blog about it, and that's what I did today. Here's to SQLcl project and Oracle 23ai: martincarstenbach.com/2025/06/25/t...
Thementage
Die Thementage Remote 2025 bieten mit 6 Konferenztagen im Livestream und über 600 Stunden Session-Aufzeichnungen eine große Bandbreite an aktuellen Entwickler-, Architektur- und IT-Betriebsthemen.
www.ittage.informatik-aktuell.de
June 25, 2025 at 1:01 PM
I had the privilege to present about CI/CD and relational databases during #Thementage25 (www.ittage.informatik-aktuell.de/thementage.h...) I promised I'd polish my demo and blog about it, and that's what I did today. Here's to SQLcl project and Oracle 23ai: martincarstenbach.com/2025/06/25/t...
Reposted by Dan McGhan
Rolling back #database changes is hard
Why?
Data!
dmcghan.bsky.social covers how to recover this in Oracle Database:
Flashback database
Database restore
Export/import
And online ways to deploy safely:
Edition-Based Redefinition
DBMS_REDEFINITION
buff.ly/r04arHd
Why?
Data!
dmcghan.bsky.social covers how to recover this in Oracle Database:
Flashback database
Database restore
Export/import
And online ways to deploy safely:
Edition-Based Redefinition
DBMS_REDEFINITION
buff.ly/r04arHd
June 18, 2025 at 11:03 AM
Rolling back #database changes is hard
Why?
Data!
dmcghan.bsky.social covers how to recover this in Oracle Database:
Flashback database
Database restore
Export/import
And online ways to deploy safely:
Edition-Based Redefinition
DBMS_REDEFINITION
buff.ly/r04arHd
Why?
Data!
dmcghan.bsky.social covers how to recover this in Oracle Database:
Flashback database
Database restore
Export/import
And online ways to deploy safely:
Edition-Based Redefinition
DBMS_REDEFINITION
buff.ly/r04arHd
Relying on Liquibase rollback? That might be your riskiest move. 💥
Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR.
👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps
Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR.
👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps
danmcghan.hashnode.dev
May 31, 2025 at 8:43 PM
Relying on Liquibase rollback? That might be your riskiest move. 💥
Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR.
👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps
Find out why it fails—and how to do it right with Oracle Flashback, Data Pump, and EBR.
👉 danmcghan.hashnode.dev/the-problems... #orclAPEX #OracleDB #sqlcl #DevOps
Reposted by Dan McGhan
Really like them!
trivadis.github.io/plsql-and-sq...
trivadis.github.io/plsql-and-sq...
PL/SQL & SQL Coding Guidelines
trivadis.github.io
May 16, 2025 at 12:50 PM
Really like them!
trivadis.github.io/plsql-and-sq...
trivadis.github.io/plsql-and-sq...
Ready to simplify CI/CD with Oracle Database? Jeff shows you how to get started with SQLcl Projects. Powerful tools, but you have to be willing to pay nothing! :D
Published two new blog posts today, but first I want to show off a new Oracle LiveLab -
livelabs.oracle.com/pls/apex/r/d...
Complete end-to-end demo for using SQLcl projects to build and maintain a React Web app with an Oracle Database backend!
livelabs.oracle.com/pls/apex/r/d...
Complete end-to-end demo for using SQLcl projects to build and maintain a React Web app with an Oracle Database backend!
livelabs.oracle.com
May 6, 2025 at 2:35 PM
Ready to simplify CI/CD with Oracle Database? Jeff shows you how to get started with SQLcl Projects. Powerful tools, but you have to be willing to pay nothing! :D
Reposted by Dan McGhan
Whenever you see "Never" or "Always" or other absolutes in claims about tech, you just know its not really about the tech, its about the clickbait....
... and yes, I'm the sucker that responds :-)
connor-mcdonald.com/2025/04/30/c...
... and yes, I'm the sucker that responds :-)
connor-mcdonald.com/2025/04/30/c...
Calling out LinkedIn Clickbait
Yeah yeah I know. You don’t have to remind me. When someone posts a LinkedIn post with the following image: then I know, you know, everyone knows, that it has been done to grab attenti…
connor-mcdonald.com
April 30, 2025 at 7:54 AM
Whenever you see "Never" or "Always" or other absolutes in claims about tech, you just know its not really about the tech, its about the clickbait....
... and yes, I'm the sucker that responds :-)
connor-mcdonald.com/2025/04/30/c...
... and yes, I'm the sucker that responds :-)
connor-mcdonald.com/2025/04/30/c...
Reposted by Dan McGhan
If you enjoy low-code development and have some free time, check out this free Oracle APEX certification—it's available at no cost until May 15.
I tried it last night, and the exam is very well designed!
blogs.oracle.com/apex/post/be...
I tried it last night, and the exam is very well designed!
blogs.oracle.com/apex/post/be...
April 16, 2025 at 2:27 PM
If you enjoy low-code development and have some free time, check out this free Oracle APEX certification—it's available at no cost until May 15.
I tried it last night, and the exam is very well designed!
blogs.oracle.com/apex/post/be...
I tried it last night, and the exam is very well designed!
blogs.oracle.com/apex/post/be...
Reposted by Dan McGhan
Reposted by Dan McGhan
We got a great overview of the capabilities of the new SQLcl Project feature. No better person to present it than @apexconsulting.nl - one of the first to use it for his CI/CD pipeline in production! In my opinion - the way APEX (and database) versioning and deployment will be done in the future 💡
April 12, 2025 at 9:59 AM
We got a great overview of the capabilities of the new SQLcl Project feature. No better person to present it than @apexconsulting.nl - one of the first to use it for his CI/CD pipeline in production! In my opinion - the way APEX (and database) versioning and deployment will be done in the future 💡
Reposted by Dan McGhan
Here's the video of APEXLang that Mike Hichwa showed in his talk this morning at #APEXWorld2025 The is massive potential here from easier ci/cd to code reviews to AI trained on the language to tooling as we'll publish the grammar behind when it launches
March 20, 2025 at 3:35 PM
Here's the video of APEXLang that Mike Hichwa showed in his talk this morning at #APEXWorld2025 The is massive potential here from easier ci/cd to code reviews to AI trained on the language to tooling as we'll publish the grammar behind when it launches
Reposted by Dan McGhan
APEX Lang is a new domain specific language you will be able to use to define Oracle APEX apps
This is a human readable language designed to help you build and manage apps faster
#apexworld2025 #orclapex
This is a human readable language designed to help you build and manage apps faster
#apexworld2025 #orclapex
March 20, 2025 at 9:05 AM
APEX Lang is a new domain specific language you will be able to use to define Oracle APEX apps
This is a human readable language designed to help you build and manage apps faster
#apexworld2025 #orclapex
This is a human readable language designed to help you build and manage apps faster
#apexworld2025 #orclapex
Reposted by Dan McGhan
New to database development? We've got a one-stop shop for your to get up to speed in just a few days
asktom.oracle.com/databases-fo...
asktom.oracle.com/databases-fo...
March 10, 2025 at 2:12 AM
New to database development? We've got a one-stop shop for your to get up to speed in just a few days
asktom.oracle.com/databases-fo...
asktom.oracle.com/databases-fo...
Reposted by Dan McGhan
Finally got a chance to try #SQLcl projects! Initially struggled, expecting it to work like Liquibase, but once I realized Git is central to the workflow, everything clicked. I think it has huge potential—not just for big teams with CI/CD, but also for beginners and citizen developers.
February 25, 2025 at 3:20 PM
Finally got a chance to try #SQLcl projects! Initially struggled, expecting it to work like Liquibase, but once I realized Git is central to the workflow, everything clicked. I think it has huge potential—not just for big teams with CI/CD, but also for beginners and citizen developers.
🚀 Feature Branches vs. End-of-Release Branches: Which is the best approach for your team? Let's dive into the pros and cons of each strategy.
danmcghan.hashnode.dev/feature-bran...
#orclAPEX #cicd
danmcghan.hashnode.dev/feature-bran...
#orclAPEX #cicd
Feature Branches vs. End-of-Release Branches: Which Approach Works Best?
The Question
Someone recently asked me:
What's the possibility/risk of just using one dev branch and multiple developers working in there, then just merge to main when a release/artifact is generated...
danmcghan.hashnode.dev
February 17, 2025 at 7:02 PM
🚀 Feature Branches vs. End-of-Release Branches: Which is the best approach for your team? Let's dive into the pros and cons of each strategy.
danmcghan.hashnode.dev/feature-bran...
#orclAPEX #cicd
danmcghan.hashnode.dev/feature-bran...
#orclAPEX #cicd
Ready to upgrade your SQLcl while working on SQLcl Projects? Timing and a structured approach are key to a smooth transition. Here's how to do it right. danmcghan.hashnode.dev/upgrading-sq...
#orclAPEX #cicd
#orclAPEX #cicd
Upgrading SQLcl When Using SQLcl Projects
Keeping your development tools up to date is essential for smooth collaboration and to take advantage of the latest features and fixes. When working with SQLcl Projects, upgrading SQLcl requires a str...
danmcghan.hashnode.dev
February 14, 2025 at 10:02 PM
Ready to upgrade your SQLcl while working on SQLcl Projects? Timing and a structured approach are key to a smooth transition. Here's how to do it right. danmcghan.hashnode.dev/upgrading-sq...
#orclAPEX #cicd
#orclAPEX #cicd
Reposted by Dan McGhan
Reposted by Dan McGhan
We’ve added a new sample application to our Gallery, demonstrating the power of Vector Search in an APEX app. Huge shoutout to our intern Nicolas for making it happen! 👏🔥 #orclapex
January 31, 2025 at 2:02 PM
We’ve added a new sample application to our Gallery, demonstrating the power of Vector Search in an APEX app. Huge shoutout to our intern Nicolas for making it happen! 👏🔥 #orclapex
Reposted by Dan McGhan
It's easy to enter duplicate customer records with small variations in their name
e.g. Smith vs Smyth
@sandra.cloudnueva.com solved this with fuzzy matching calling
UTL_MATCH.JARO_WINKLER_SIMILARITY
in Oracle #SQL to find possible matches when making new customers
e.g. Smith vs Smyth
@sandra.cloudnueva.com solved this with fuzzy matching calling
UTL_MATCH.JARO_WINKLER_SIMILARITY
in Oracle #SQL to find possible matches when making new customers
buff.ly
January 29, 2025 at 12:00 PM
It's easy to enter duplicate customer records with small variations in their name
e.g. Smith vs Smyth
@sandra.cloudnueva.com solved this with fuzzy matching calling
UTL_MATCH.JARO_WINKLER_SIMILARITY
in Oracle #SQL to find possible matches when making new customers
e.g. Smith vs Smyth
@sandra.cloudnueva.com solved this with fuzzy matching calling
UTL_MATCH.JARO_WINKLER_SIMILARITY
in Oracle #SQL to find possible matches when making new customers
Reposted by Dan McGhan
APEX Developer Blogs now allows you to perform a 23ai Vector/Semantic Search and/or ask questions on all 3,000+ APEX Developer blogs using RAG. Head over to the Chat & Search option at apps.cloudnueva.com/apexblogs #orclapex
Oracle APEX Developer Blogs and Videos
Aggregates blogs and videos related to Oracle APEX and Oracle APEX-related development tech.
apps.cloudnueva.com
January 28, 2025 at 12:34 AM
APEX Developer Blogs now allows you to perform a 23ai Vector/Semantic Search and/or ask questions on all 3,000+ APEX Developer blogs using RAG. Head over to the Chat & Search option at apps.cloudnueva.com/apexblogs #orclapex
Reposted by Dan McGhan
Oracle APEX 24.2 is now generally available!
This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more!
apex.oracle.com/go/242-is-no...
#orclAPEX #LowCode
This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more!
apex.oracle.com/go/242-is-no...
#orclAPEX #LowCode
January 15, 2025 at 2:14 PM
Oracle APEX 24.2 is now generally available!
This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more!
apex.oracle.com/go/242-is-no...
#orclAPEX #LowCode
This release unlocks new capabilities for AI-powered apps 🤖, configure RAG data for AI calls🧠, automate Fusion Applications integration🔁, work directly with JSON data ✨, and much more!
apex.oracle.com/go/242-is-no...
#orclAPEX #LowCode
New blog post: Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments danmcghan.hashnode.dev/admin-vs-app...
#orclAPEX #cicd
#orclAPEX #cicd
Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments
Choosing the right deployment approach is essential when deploying changes to Oracle Database and APEX applications. One key decision involves selecting between an admin (privileged) user installation...
danmcghan.hashnode.dev
January 4, 2025 at 4:39 PM
New blog post: Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments danmcghan.hashnode.dev/admin-vs-app...
#orclAPEX #cicd
#orclAPEX #cicd
Reposted by Dan McGhan
SQL domains make data models easier to understand and reduce the logic regarding data consistency and visualisation. How easy is it to change domains and propagate those changes to the underlying tables?
Season's greetings and a happy new year!
www.salvis.com/blog/2024/12...
Season's greetings and a happy new year!
www.salvis.com/blog/2024/12...
Evolution of a SQL Domain for Semantic Versioning - Philipp Salvisberg's Blog
SQL domains abstract column properties for use across multiple tables. I demonstrate the evolution of a domain for Semantic Versioning.
www.salvis.com
December 24, 2024 at 2:28 PM
SQL domains make data models easier to understand and reduce the logic regarding data consistency and visualisation. How easy is it to change domains and propagate those changes to the underlying tables?
Season's greetings and a happy new year!
www.salvis.com/blog/2024/12...
Season's greetings and a happy new year!
www.salvis.com/blog/2024/12...
My first blog post in years: An Overview of the Oracle SQLcl Projects Development Process danmcghan.hashnode.dev/an-overview-...
#orclAPEX
#orclAPEX
An Overview of the Oracle SQLcl Projects Development Process
SQLcl Projects is a new feature of SQLcl that aims to standardize and streamline the development lifecycle of Oracle Database applications. This post provides a high level overview of what the develop...
danmcghan.hashnode.dev
December 20, 2024 at 5:38 PM
My first blog post in years: An Overview of the Oracle SQLcl Projects Development Process danmcghan.hashnode.dev/an-overview-...
#orclAPEX
#orclAPEX
The Quick Start guide for SQLcl Projects was recently overhauled by @martindsouza
😍: docs.oracle.com/en/database/...
Use this guide to kick the tires and see how SQLcl Projects can help with CI/CD on your Oracle Database and #orclAPEX apps!
😍: docs.oracle.com/en/database/...
Use this guide to kick the tires and see how SQLcl Projects can help with CI/CD on your Oracle Database and #orclAPEX apps!
User's Guide
docs.oracle.com
December 12, 2024 at 1:37 PM
The Quick Start guide for SQLcl Projects was recently overhauled by @martindsouza
😍: docs.oracle.com/en/database/...
Use this guide to kick the tires and see how SQLcl Projects can help with CI/CD on your Oracle Database and #orclAPEX apps!
😍: docs.oracle.com/en/database/...
Use this guide to kick the tires and see how SQLcl Projects can help with CI/CD on your Oracle Database and #orclAPEX apps!