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

Tag

# #oracle-plsql

39 posts · 69 followers

[John Scott](https://hashnode.com/@jes-dev) · [Oct 26](https://hashnode.com/posts/generating-a-word-document-using-node-oracledb-and-etch/6adf759c7a752cdd73090a30)

### [Generating a Word document using node-oracledb and ETCH](https://jes-dev.hashnode.dev/generating-a-word-document-using-node-oracledb-and-etch?utm_source=hashnode&utm_medium=feed)

A Word document from an Oracle query, containing a BLOB of photos and a Word template, in about thirty lines of Node.js

4 min read · [jes-dev.hashnode.dev](https://jes-dev.hashnode.dev/generating-a-word-document-using-node-oracledb-and-etch?utm_source=hashnode&utm_medium=feed)

[Phil Grinham](https://hashnode.com/@PhilGrinham) · [Oct 14](https://hashnode.com/posts/bubble-sorting-delimited-strings-joelkallmanday/6acf434447cc217465c77993)

### [Bubble Sorting Delimited Strings #JoelKallmanDay](https://philgrinham.hashnode.dev/bubble-sorting-delimited-strings-joelkallmanday?utm_source=hashnode&utm_medium=feed)

In honor Joel and all he did for the Oracle community, this is a quick blog post on a solution to the problem of sorting a delimited string. The basic premise is a common headache where we are require

7 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/bubble-sorting-delimited-strings-joelkallmanday?utm_source=hashnode&utm_medium=feed)

[Sushama Jangle](https://hashnode.com/@sushamaj) · [Aug 3](https://hashnode.com/posts/viewing-pdf-files-in-oracle-apex-creating-a-seamless-document-experience-for-business-users/6a70c869d94c3204cecee2f5)

### [Viewing PDF Files in Oracle APEX: Creating a Seamless Document Experience for Business Users](https://oracleapexsessionstate.hashnode.dev/viewing-pdf-files-in-oracle-apex-creating-a-seamless-document-experience-for-business-users?utm_source=hashnode&utm_medium=feed)

How embedding PDF viewing directly into Oracle APEX improves productivity, reduces context switching, and enhances enterprise workflows.

4 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/viewing-pdf-files-in-oracle-apex-creating-a-seamless-document-experience-for-business-users?utm_source=hashnode&utm_medium=feed)

[Sushama Jangle](https://hashnode.com/@sushamaj) · [Jul 30](https://hashnode.com/posts/from-standard-report-to-excel-like-experience-enhancing-oracle-apex-interactive-report-with-frozen-columns/6a6b96e53809d0bcccf32e66)

### [From Standard Report to Excel-Like Experience: Enhancing Oracle APEX Interactive Report with Frozen Columns](https://oracleapexsessionstate.hashnode.dev/from-standard-report-to-excel-like-experience-enhancing-oracle-apex-interactive-report-with-frozen-columns?utm_source=hashnode&utm_medium=feed)

Great applications aren't defined only by powerful features—they're remembered for how easy they are to use.

6 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/from-standard-report-to-excel-like-experience-enhancing-oracle-apex-interactive-report-with-frozen-columns?utm_source=hashnode&utm_medium=feed)

[Phil Grinham](https://hashnode.com/@PhilGrinham) · [Jun 30](https://hashnode.com/posts/materialized-views-the-sweet-spot/6a453454fbfc9f1ee09e7f17)

### [Materialized Views: The Sweet Spot](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed)

The Inspiration I recently read an article from the always excellent Connor McDonald that I highly recommend where he provided a solution on how to maintain a materialized view that needs to be "up to

9 min read · [philgrinham.hashnode.dev](https://philgrinham.hashnode.dev/materialized-views-the-sweet-spot?utm_source=hashnode&utm_medium=feed)

[Juan Andrés López](https://hashnode.com/@andreslopezher) · [May 29](https://hashnode.com/posts/oracle-finally-did-it-boolean-is-now-supported-directly-in-sql/6a198c4644ce1bc53ead0551)

### [Oracle finally did it: BOOLEAN is now supported directly in SQL.](https://metadriven.hashnode.dev/oracle-finally-did-it-boolean-is-now-supported-directly-in-sql?utm_source=hashnode&utm_medium=feed)

And It Was Worth the Wait

6 min read · [metadriven.hashnode.dev](https://metadriven.hashnode.dev/oracle-finally-did-it-boolean-is-now-supported-directly-in-sql?utm_source=hashnode&utm_medium=feed)

[Naif Amoodi](https://hashnode.com/@naifamoodi) · [Apr 23](https://hashnode.com/posts/working-around-an-old-oracle-database/69ea10a873da2cf26b1aaaa2)

### [Working Around an Old Oracle Database](https://naifamoodi.hashnode.dev/working-around-an-old-oracle-database?utm_source=hashnode&utm_medium=feed)

We still work with a client whose day-to-day operation depends heavily on an old Oracle database, so a lot of our integration work ends up being shaped by the quirks of that database. One thing I lear

2 min read · [naifamoodi.hashnode.dev](https://naifamoodi.hashnode.dev/working-around-an-old-oracle-database?utm_source=hashnode&utm_medium=feed)

[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) · [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)
