---
title: "#plsql articles | Hashnode"
description: "The procedural language used alongside with SQL in Oracle Databases. Read the latest #plsql articles and tutorials on Hashnode."
url: "https://hashnode.com/tag/plsql"
---

Tag

# #plsql

179 posts · 137 followers

[Sushama Jangle](https://hashnode.com/@sushamaj) · [10h ago](https://hashnode.com/posts/building-a-notification-center-in-oracle-apex-what-i-built-and-how-it-works/6afc8e9e0ec7e06f0ac08712)

### [Building a Notification Center in Oracle APEX: What I Built and How It Works](https://oracleapexsessionstate.hashnode.dev/building-a-notification-center-in-oracle-apex-what-i-built-and-how-it-works?utm_source=hashnode&utm_medium=feed)

A practical implementation using PL/SQL, Interactive Reports, Dynamic Actions, and session-based user notifications — with the design decisions, testing scenarios, and issues I encountered along the way.

14 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/building-a-notification-center-in-oracle-apex-what-i-built-and-how-it-works?utm_source=hashnode&utm_medium=feed)

[Sushama Jangle](https://hashnode.com/@sushamaj) · [1d ago](https://hashnode.com/posts/how-i-track-api-requests-and-errors-in-oracle-apex/6afb3b628f09dcbc683fb1e5)

### [How I Track API Requests and Errors in Oracle APEX](https://oracleapexsessionstate.hashnode.dev/how-i-track-api-requests-and-errors-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

Build a practical API monitoring and replay console using Oracle APEX, PL/SQL, and APEX\_WEB\_SERVICE.

17 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/how-i-track-api-requests-and-errors-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Sushama Jangle](https://hashnode.com/@sushamaj) · [2d ago](https://hashnode.com/posts/building-a-qr-code-and-barcode-based-inventory-scanner-in-oracle-apex/6af9d59b50526ccd8f87a339)

### [Building a QR Code and Barcode-Based Inventory Scanner in Oracle APEX](https://oracleapexsessionstate.hashnode.dev/building-a-qr-code-and-barcode-based-inventory-scanner-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

How I explored mobile camera scanning with JavaScript, Oracle APEX and PL/SQL to make product identification easier.

16 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/building-a-qr-code-and-barcode-based-inventory-scanner-in-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Asfaq Leeon](https://hashnode.com/@leeonscoding) · [2d ago](https://hashnode.com/posts/pl-pgsql-for-people-who-already-know-sql/6afa5a280830de9cd6a7069c)

### [PL/pgSQL for People Who Already Know SQL](https://leeonscoding.hashnode.dev/pl-pgsql-for-people-who-already-know-sql?utm_source=hashnode&utm_medium=feed)

A fast revision sheet: procedural PostgreSQL, from variables to triggers, and when not to use it. Postgres's procedural language is PL/pgSQL, a close cousin of Oracle's PL/SQL. Syntax differs in plac

15 min read · [leeonscoding.hashnode.dev](https://leeonscoding.hashnode.dev/pl-pgsql-for-people-who-already-know-sql?utm_source=hashnode&utm_medium=feed)

[Sushama Jangle](https://hashnode.com/@sushamaj) · [3d ago](https://hashnode.com/posts/building-an-api-monitoring-and-automatic-retry-framework-using-oracle-apex/6af7f3fe87b21ac7a837cf79)

### [Building an API Monitoring and Automatic Retry Framework Using Oracle APEX](https://oracleapexsessionstate.hashnode.dev/building-an-api-monitoring-and-automatic-retry-framework-using-oracle-apex?utm_source=hashnode&utm_medium=feed)

Track API executions | Capture failures | Manage retries | Monitor everything from one dashboard

8 min read · [oracleapexsessionstate.hashnode.dev](https://oracleapexsessionstate.hashnode.dev/building-an-api-monitoring-and-automatic-retry-framework-using-oracle-apex?utm_source=hashnode&utm_medium=feed)

[Ejaz Arain](https://hashnode.com/@ejazarain) · [4d ago](https://hashnode.com/posts/a-cast-to-five-bytes-and-a-two-character-word/6af6d3bbe9abe11193821938)

### [A cast to five bytes and a two-character word](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

First published on the Tech Style blog. CAST('中文' AS VARCHAR2(5)) asks for five bytes of a value that takes six. Each of the two characters is three bytes long in a UTF-8 database, so the fifth byte f

3 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/a-cast-to-five-bytes-and-a-two-character-word?utm_source=hashnode&utm_medium=feed)

[Timo Herwix](https://hashnode.com/@timoherwix) · [Nov 6](https://hashnode.com/posts/beyond-sso-extracting-saml-group-claims-in-oracle-apex-with-pl-sql/6aedd8ee0fa8ab38bf0804ea)

### [Beyond SSO: Extracting SAML Group Claims in Oracle APEX with PL/SQL](https://tm-apex.hashnode.dev/beyond-sso-extracting-saml-group-claims-in-oracle-apex-with-pl-sql?utm_source=hashnode&utm_medium=feed)

Part 3: Extending SAML Sign-In with a Post-Authentication Procedure

10 min read · [tm-apex.hashnode.dev](https://tm-apex.hashnode.dev/beyond-sso-extracting-saml-group-claims-in-oracle-apex-with-pl-sql?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/beyond-sso-extracting-saml-group-claims-in-oracle-apex-with-pl-sql/6aedd8ee0fa8ab38bf0804ea)

[Arfaat Shaikh](https://hashnode.com/@apexcraftswitharfaat) · [Nov 6](https://hashnode.com/posts/one-oracle-apex-app-many-ways-to-sign-in/6aee11a96d23945c4e908bd8)

### [One Oracle APEX App, Many Ways to Sign In](https://apexcraftsbyarfaat.hashnode.dev/one-oracle-apex-app-many-ways-to-sign-in?utm_source=hashnode&utm_medium=feed)

Learn how to implement multiple login methods in Oracle APEX using password, Google OAuth, and face recognition with one shared user table.

9 min read · [apexcraftsbyarfaat.hashnode.dev](https://apexcraftsbyarfaat.hashnode.dev/one-oracle-apex-app-many-ways-to-sign-in?utm_source=hashnode&utm_medium=feed)

[2](https://hashnode.com/posts/one-oracle-apex-app-many-ways-to-sign-in/6aee11a96d23945c4e908bd8)

[David Pataki](https://hashnode.com/@enrol) · [Nov 6](https://hashnode.com/posts/building-ci-cd-for-oracle-apex-part-3-when-can-i-trust-a-snapshot/6aed855c811efc2e7c971d42)

### [Building CI/CD for Oracle APEX – Part 3: When Can I Trust a Snapshot?](https://davidpataki.com/building-ci-cd-for-oracle-apex-part-3-when-can-i-trust-a-snapshot?utm_source=hashnode&utm_medium=feed)

How I make Oracle APEX CI/CD snapshots reliable across DEV, TEST and PROD using checkpoints, idempotent imports and safe audit collection.

8 min read · [davidpataki.com](https://davidpataki.com/building-ci-cd-for-oracle-apex-part-3-when-can-i-trust-a-snapshot?utm_source=hashnode&utm_medium=feed)

[Ejaz Arain](https://hashnode.com/@ejazarain) · [Nov 6](https://hashnode.com/posts/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends/6aedc62890d9e8e06386310e)

### [Paritas: an Oracle-compatible database built on PostgreSQL that tells you where compatibility ends](https://rutba.hashnode.dev/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends?utm_source=hashnode&utm_medium=feed)

Paritas is PostgreSQL 18 with an Oracle mode. How we test it against a real Oracle, and our list of where compatibility ends.

5 min read · [rutba.hashnode.dev](https://rutba.hashnode.dev/paritas-an-oracle-compatible-database-built-on-postgresql-that-tells-you-where-compatibility-ends?utm_source=hashnode&utm_medium=feed)
