---
title: "Dan McGhan (@dmcghan) | Hashnode"
description: "Oracle Database Development. Read the latest articles by Dan McGhan on Hashnode."
url: "https://hashnode.com/@dmcghan"
---

@dmcghan

# Dan McGhan

@dmcghan · Fort Mill, SC · Joined November 2024

Oracle Database Development

### [Schema-agnostic Staged Changesets with stage.substituteSchemas](https://danmcghan.hashnode.dev/schema-agnostic-staged-changesets-with-stage-substituteschemas?utm_source=hashnode&utm_medium=feed)

Make SQLcl staged files schema-agnostic by substituting schema names with Liquibase variables for deploy-anywhere artifacts.

6 min read · [danmcghan.hashnode.dev](https://danmcghan.hashnode.dev/schema-agnostic-staged-changesets-with-stage-substituteschemas?utm_source=hashnode&utm_medium=feed)

[Apr 3](https://hashnode.com/posts/schema-agnostic-staged-changesets-with-stage-substituteschemas/69cfba2f21e7d635066ede58)

### [The Problems with Liquibase Rollback — and What to Do Instead](https://danmcghan.hashnode.dev/the-problems-with-liquibase-rollback-and-what-to-do-instead?utm_source=hashnode&utm_medium=feed)

Liquibase rollback may seem reliable, but it often fails in real-world deployments—especially when data is involved. Learn why and explore safer alternative

4 min read · [danmcghan.hashnode.dev](https://danmcghan.hashnode.dev/the-problems-with-liquibase-rollback-and-what-to-do-instead?utm_source=hashnode&utm_medium=feed)

[May 31, 2025](https://hashnode.com/posts/the-problems-with-liquibase-rollback-and-what-to-do-instead/683b58decc2fb3fe4b8669d9)

### [Feature Branches vs. End-of-Release Branches: Which Approach Works Best?](https://danmcghan.hashnode.dev/feature-branches-vs-end-of-release-branches-which-approach-works-best?utm_source=hashnode&utm_medium=feed)

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? Good Practice? Bad Practice? Thoughts? Risky Bu...

3 min read · [danmcghan.hashnode.dev](https://danmcghan.hashnode.dev/feature-branches-vs-end-of-release-branches-which-approach-works-best?utm_source=hashnode&utm_medium=feed)

[Feb 17, 2025](https://hashnode.com/posts/feature-branches-vs-end-of-release-branches-which-approach-works-best/67b3868166a89668211392c8)

### [Upgrading SQLcl When Using SQLcl Projects](https://danmcghan.hashnode.dev/upgrading-sqlcl-when-using-sqlcl-projects?utm_source=hashnode&utm_medium=feed)

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 structured approach to minimize disruption and ensure...

3 min read · [danmcghan.hashnode.dev](https://danmcghan.hashnode.dev/upgrading-sqlcl-when-using-sqlcl-projects?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/upgrading-sqlcl-when-using-sqlcl-projects/67afbb9a75deea5e312ccf54) [Feb 14, 2025](https://hashnode.com/posts/upgrading-sqlcl-when-using-sqlcl-projects/67afbb9a75deea5e312ccf54)

### [Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments](https://danmcghan.hashnode.dev/admin-vs-app-user-installation-choosing-the-right-path-for-secure-efficient-deployments?utm_source=hashnode&utm_medium=feed)

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 and an app (object owner) user installation. Each...

5 min read · [danmcghan.hashnode.dev](https://danmcghan.hashnode.dev/admin-vs-app-user-installation-choosing-the-right-path-for-secure-efficient-deployments?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/admin-vs-app-user-installation-choosing-the-right-path-for-secure-efficient-deployments/6779633e5a15106fc38de10c) [Jan 4, 2025](https://hashnode.com/posts/admin-vs-app-user-installation-choosing-the-right-path-for-secure-efficient-deployments/6779633e5a15106fc38de10c)
