Archive

321 posts published so far

Jul 5, 2025
SQLcl host Command
Martin Giffy D'Souza
Jan 22, 2024
Tips for APEX Application Constants
Martin Giffy D'Souza
Jan 22, 2024
SQL Developer for VS Code
Martin Giffy D'Souza
Jan 17, 2024
How to Generate a sitemap.xml in SQL
Martin Giffy D'Souza
Jan 15, 2024
What Happens to APEX Page Items that are Never Rendered?
Martin Giffy D'Souza
Jan 10, 2024
Case Insensitive Searching in APEX
Martin Giffy D'Souza
Jan 8, 2024
Data Integrity for Fast Refresh Materialized Views with Aggregates and Updates/Deletes
Martin Giffy D'Souza
Jan 5, 2024
How to Get a Non-Aggregate value in an Aggregate Query
Martin Giffy D'Souza
Jan 3, 2024
Dot Notation for JSON in Oracle SQL
Martin Giffy D'Souza
Nov 27, 2023
How to customize Page Designer layout in APEX
Martin Giffy D'Souza
Nov 26, 2023
APEX_STRING.SPLIT, Pipelined Functions, and Pickler Fetches
Martin Giffy D'Souza
Nov 26, 2023
Regular expression patterns [[:upper:]] vs [A-Z]
Martin Giffy D'Souza
Nov 25, 2023
Oracle SQL Listagg for Clobs
Martin Giffy D'Souza
Nov 25, 2023
How to merge JSON objects in SQL
Martin Giffy D'Souza
Nov 25, 2023
How to find which item has been changed in APEX
Martin Giffy D'Souza
Jan 31, 2021
The Biggest Hidden Bug in Your APEX Application
Martin Giffy D'Souza
Jan 31, 2021
Inline Function in Dynamic Action JavaScript Expression in APEX
Martin Giffy D'Souza
Jan 17, 2021
How to Quickly Build Templates in APEX Office Print
Martin Giffy D'Souza
Nov 14, 2020
SQLDeveloper in macOS Big Sur
Martin Giffy D'Souza
Apr 28, 2020
Screenshots in macOS and Continuity Markup
Martin Giffy D'Souza
Mar 26, 2020
APEX@Home
Martin Giffy D'Souza
Mar 13, 2020
APEX 19 Form PL/SQL Processing
Martin Giffy D'Souza
Mar 12, 2020
How to Easily Reload Modal Pages in APEX
Martin Giffy D'Souza
Mar 11, 2020
How to Share SQLcl Aliases
Martin Giffy D'Souza
Mar 5, 2020
Catching NO_DATA_NEEDED Exception in Pipelined Functions
Martin Giffy D'Souza

SQLcl host Command

Tips for APEX Application Constants

SQL Developer for VS Code

How to Generate a sitemap.xml in SQL

What Happens to APEX Page Items that are Never Rendered?

Case Insensitive Searching in APEX

Data Integrity for Fast Refresh Materialized Views with Aggregates and Updates/Deletes

How to Get a Non-Aggregate value in an Aggregate Query

Dot Notation for JSON in Oracle SQL

How to customize Page Designer layout in APEX

APEX_STRING.SPLIT, Pipelined Functions, and Pickler Fetches

Regular expression patterns [[:upper:]] vs [A-Z]

Oracle SQL Listagg for Clobs

How to merge JSON objects in SQL

How to find which item has been changed in APEX

The Biggest Hidden Bug in Your APEX Application

Inline Function in Dynamic Action JavaScript Expression in APEX

How to Quickly Build Templates in APEX Office Print

SQLDeveloper in macOS Big Sur

Screenshots in macOS and Continuity Markup

APEX@Home

APEX 19 Form PL/SQL Processing

How to Easily Reload Modal Pages in APEX

How to Share SQLcl Aliases

Catching NO_DATA_NEEDED Exception in Pipelined Functions