DSP Blog

Latest Posts

Exporting data Using APEX_DATA_EXPORT

What is APEX_DATA_EXPORT APEX_DATA_EXPORT was introduced along with APEX_REGION.EXPORT_DATA in APEX 20.2, to allow developers to easily extract and download data. APEX_DATA_EXPORT..

Read More

Oracle EBS Archive Managed Service: Simplify Your Data Management

Efficiently managing data has become crucial for organisations in today's rapidly evolving business landscape. With the ever-increasing volumes of data being generated and stored,..

Read More

Connecting Worlds - APEX and WooCommerce REST Synchronisation

In today's fast-paced digital world, it's essential for businesses to integrate different platforms to achieve efficiency and productivity seamlessly. Two of the most powerful..

Read More

Oracle's Critical Patch Update October 2023

Every quarter, Oracle releases a Critical Patch Update (CPU) that contains a collection of fixes for various security vulnerabilities. These patches are designed to address..

Read More

Top 10 Signs Your SQL Server Needs a Health Check

When was the last time you underwent a thorough SQL Server Health Check? If you can't remember, or if it's been quite a while, now might be the right time to consider one. Just..

Read More

Power BI vs. Qlik Sense

There are plenty of reporting solutions out there, but I wanted to compare two of the most well-known to see how easy they are to connect to an Oracle Database, what options are..

Read More

Methods on Tables and Beyond – Auto-generation of code for APEX Applications

When developing APEX applications, native DML is the obvious way to go as it handles DML operations without having to write custom code. However, in many real-world scenarios,..

Read More

Exporting Custom Interactive Reports via REST

On a recent project, I was tasked with developing a module within an APEX application to receive a JSON file via a REST API. This was so it could be manipulated on screen before..

Read More

The Power of Software Asset Management (SAM)

Managing software assets has become a paramount concern for organisations seeking to maintain a competitive edge while optimising costs and ensuring compliance in line with IT..

Read More