---
title: "#oracle-sql articles | Hashnode"
description: "Explore 20 articles tagged #oracle-sql on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/oracle-sql"
---

Tag

# #oracle-sql

20 posts · 31 followers

[Benjamin Intsiful](https://hashnode.com/@bintsiful) · [Mar 19](https://hashnode.com/posts/stop-hacking-data-integrity-moving-from-trigger-gymnastics-to-26ai-assertions/69bc071bb238fd45a3027ec6)

### [Stop Hacking Data Integrity: Moving from Trigger Gymnastics to 26ai Assertions](https://bintsiful.hashnode.dev/stop-hacking-data-integrity-moving-from-trigger-gymnastics-to-26ai-assertions?utm_source=hashnode&utm_medium=feed)

For a long time, compound triggers have been the unsung heroes of the Oracle world. They weren't always our first choice because of their complexity, but they were the reliable "Swiss Army knives" we

5 min read · [bintsiful.hashnode.dev](https://bintsiful.hashnode.dev/stop-hacking-data-integrity-moving-from-trigger-gymnastics-to-26ai-assertions?utm_source=hashnode&utm_medium=feed)

[Benjamin Intsiful](https://hashnode.com/@bintsiful) · [Mar 17](https://hashnode.com/posts/what-a-room-booking-question-on-oracle-forums-taught-me-about-data-modeling-in-oracle-apex/69b96c4dc22d3eeb8ac1f860)

### [What a Room Booking Question on Oracle Forums Taught Me About Data Modeling in Oracle APEX](https://bintsiful.hashnode.dev/what-a-room-booking-question-on-oracle-forums-taught-me-about-data-modeling-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

I was recently poking around the Oracle developer community—specifically the Oracle SQL&PL/SQL Forums, which is still a goldmine if you can ignore the occasional grumpy old-timer—and found a guy strug

7 min read · [bintsiful.hashnode.dev](https://bintsiful.hashnode.dev/what-a-room-booking-question-on-oracle-forums-taught-me-about-data-modeling-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Benjamin Intsiful](https://hashnode.com/@bintsiful) · [Mar 11](https://hashnode.com/posts/effortless-json-generation-in-oracle-apex-part-2/69b165916c896b05198f5a11)

### [Effortless JSON Generation in Oracle APEX — Part 2](https://bintsiful.hashnode.dev/effortless-json-generation-in-oracle-apex-part-2?utm_source=hashnode&utm_medium=feed)

What Oracle Database 26ai Actually Changes (From an APEX Developer’s Perspective) If Part 1 was about finally stopping the manual JSON pain,this part is about something more subtle: realizing SQL is

5 min read · [bintsiful.hashnode.dev](https://bintsiful.hashnode.dev/effortless-json-generation-in-oracle-apex-part-2?utm_source=hashnode&utm_medium=feed)

[Benjamin Intsiful](https://hashnode.com/@bintsiful) · [Feb 28](https://hashnode.com/posts/count-is-a-performance-trap/69a2f3620728161017e9f00d)

### [Why COUNT(\*) Is a Performance Trap](https://bintsiful.hashnode.dev/count-is-a-performance-trap?utm_source=hashnode&utm_medium=feed)

Just like most teams that practice Agile methodologies some years ago; It was 4:15 PM. The sprint demo was live. The dashboard looked great until someone clicked the "Customer Health" tab. Then? Silen

5 min read · [bintsiful.hashnode.dev](https://bintsiful.hashnode.dev/count-is-a-performance-trap?utm_source=hashnode&utm_medium=feed)

[Chetana Suresh Apraj](https://hashnode.com/@chetana167) · [Jan 21](https://hashnode.com/posts/xml-insights-with-oracle/69709599667e8115879c0d61)

### [XML Insights with Oracle](https://xml-insights-with-oracle.hashnode.dev/xml-insights-with-oracle?utm_source=hashnode&utm_medium=feed)

1) XML in Oracle SQL (XML to table) Key Data Types & Functions XMLTYPE: Native type to store and query XML. XPath/XQuery via: XMLTABLE (preferred for shredding XML into rows/columns), XMLQUERY, XMLCAST, Legacy EXTRACT() / EXTRACTVALUE() (depreca...

8 min read · [xml-insights-with-oracle.hashnode.dev](https://xml-insights-with-oracle.hashnode.dev/xml-insights-with-oracle?utm_source=hashnode&utm_medium=feed)

[Richard](https://hashnode.com/@Apexblog) · [Nov 7, 2025](https://hashnode.com/posts/internet-links/690e10cecfc55db02b2b719f)

### [Internet Links](https://apexblog.hashnode.dev/internet-links?utm_source=hashnode&utm_medium=feed)

General links Free SQL (online) Try it! Oracle 26AI - documentation Authors That Jeff Smith.com Database recipes and tips Articles Open page in another Apex application

1 min read · [apexblog.hashnode.dev](https://apexblog.hashnode.dev/internet-links?utm_source=hashnode&utm_medium=feed)

[Sakthi Santhana Lakshmi](https://hashnode.com/@Sakthi27) · [Jul 28, 2025](https://hashnode.com/posts/why-learning-oracle-sql-is-essential-for-every-aspiring-developer/688766315c02680f2e4b0d54)

### [Why Learning Oracle SQL is Essential for Every Aspiring Developer](https://best-python-certification-course-in-chennai-intellinindz.hashnode.dev/why-learning-oracle-sql-is-essential-for-every-aspiring-developer?utm_source=hashnode&utm_medium=feed)

Discover why Oracle SQL is vital for developers and how Oracle SQL Training in Chennai at IntelliMindz builds hands-on skills and job-ready expertise.

6 min read · [best-python-certification-course-in-chennai-intellinindz.hashnode.dev](https://best-python-certification-course-in-chennai-intellinindz.hashnode.dev/why-learning-oracle-sql-is-essential-for-every-aspiring-developer?utm_source=hashnode&utm_medium=feed)

[Sujan Haldar](https://hashnode.com/@hsujan) · [Feb 3, 2025](https://hashnode.com/posts/plsql1/67a10f9b6e6a30c5021d1deb)

### [Introduction to PL/SQL](https://hsujan.hashnode.dev/plsql1?utm_source=hashnode&utm_medium=feed)

Learn the fundamentals of PL/SQL, Oracle's procedural extension for SQL. Explore its block structure, integration with SQL, error handling, and more

8 min read · [hsujan.hashnode.dev](https://hsujan.hashnode.dev/plsql1?utm_source=hashnode&utm_medium=feed)

[Lucas Hirschegger](https://hashnode.com/@lucashir) · [Oct 15, 2024](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24)

### [SQL - Calculating Date Offset While Excluding Weekends](https://blog.lucashir.eu/sql-calculating-date-offset-while-excluding-weekends?utm_source=hashnode&utm_medium=feed)

In a current project, I needed to calculate the date offset while excluding weekends. Initially, this was solved using a loop in PL/SQL, which I consider a less efficient approach. To optimize it, I created a straightforward SQL query that handles th...

2 min read · [blog.lucashir.eu](https://blog.lucashir.eu/sql-calculating-date-offset-while-excluding-weekends?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/sql-calculating-date-offset-while-excluding-weekends/670e422139c9633aa18c4e24)

[Gautami Shetty](https://hashnode.com/@GautamiShetty) · [Aug 28, 2024](https://hashnode.com/posts/datatype-in-oracle-sql/6713335f954990d4e4ac2910)

### [Datatype in Oracle SQL](https://gautamishetty.hashnode.dev/datatype-in-oracle-sql?utm_source=hashnode&utm_medium=feed)

A Beginner's Guide to Datatypes in Oracle SQL

2 min read · [gautamishetty.hashnode.dev](https://gautamishetty.hashnode.dev/datatype-in-oracle-sql?utm_source=hashnode&utm_medium=feed)
