Articles

Long-form posts and guides on data science, vectors, and Oracle technologies.

Multicloud made easy: Oracle’s game-changing approach to cloud harmony

Leave a Comment / Articles, OCI /

If you’re facing challenges managing workloads across different clouds and want to integrate them seamlessly, this read is for you. Recently, I completed a course on Oracle’s multicloud capabilities and had the chance to dive deeper into how Oracle integrates with major cloud providers like Google Cloud, AWS, and Azure. I wanted to share my […]

Multicloud made easy: Oracle’s game-changing approach to cloud harmony Read More »

Performing REST API Calls in Oracle APEX with PL/SQL Code

Leave a Comment / Articles, Oracle APEX /

In Oracle APEX, REST API calls can be performed using either Shared Components (Web Source Modules) or through PL/SQL processes. While Shared Components provide simplicity and built-in tools, sometimes you need greater control over the request, response, and processing logic. In this article, I’ll show you how to perform REST API calls using pure PL/SQL

Performing REST API Calls in Oracle APEX with PL/SQL Code Read More »

Creating Reports and Documents with APEX Office Print in Oracle APEX

Leave a Comment / Articles, Oracle APEX /

APEX is an incredibly versatile platform for building low-code applications, but one feature that really elevates its capabilities is the ability to generate professional-quality reports and documents. While APEX provides some built-in reporting tools, integrating it with APEX Office Print (AOP) takes things to a whole new level, especially for creating customizable Word, PDF, and

Creating Reports and Documents with APEX Office Print in Oracle APEX Read More »

Creating my own specialized ChatGPT for Oracle APEX Development using Fine-Tuned OpenAI models

Leave a Comment / Articles, OCI Data Science, Oracle APEX /

As a developer working with Oracle APEX, staying updated with the latest features and enhancements is crucial for building scalable and secure applications. While tools like ChatGPT have become invaluable for coding assistance, I’ve often found that its knowledge of specific technologies can lag behind the latest updates. This is particularly true when new versions

Creating my own specialized ChatGPT for Oracle APEX Development using Fine-Tuned OpenAI models Read More »

Configuring Email in OracleAPEX on an AutonomousDatabase (ADB)

Leave a Comment / Articles, Oracle APEX /

Email functionality is vital for many Oracle APEX applications, whether it’s sending notifications, confirmations, or updates to users. Deployments on an Autonomous Database (ADB), have by default added layers of security that make adoption and migration a bit challenging. Oracle documents the key differences, constraints inherent to Autonomous Database for experienced Oracle Database users. The

Configuring Email in OracleAPEX on an AutonomousDatabase (ADB) Read More »

Unlock the Power of AI in Oracle APEX 24.1: Set Up OpenAI Credentials for APEX Assistant

Leave a Comment / Articles, Oracle APEX /

Oracle APEX 24.1 has introduced an exciting new feature: the APEX Assistant, which leverages OpenAI’s large language model to help developers generate code and receive intelligent suggestions during app development. In this article, I’ll walk you through the steps to set up your OpenAI credentials in Oracle APEX and enable the AI Assistant for your

Unlock the Power of AI in Oracle APEX 24.1: Set Up OpenAI Credentials for APEX Assistant Read More »

Leveraging Machine Learning for Image Clustering: A Case Study with a Museum’s Digital Archive

Leave a Comment / Articles, OCI Data Science, Oracle APEX /

Introduction In today’s digital age, museums are increasingly embracing technology to manage and analyze their vast collections. I recently had the opportunity to collaborate with a museum that houses a wealth of historical artifacts captured in digital images. The challenge was to extract meaningful information from these images to assist curators in identifying patterns and

Leveraging Machine Learning for Image Clustering: A Case Study with a Museum’s Digital Archive Read More »

How to Modify Your Interactive Grid Using JavaScript in Oracle APEX

1 Comment / Articles, Oracle APEX /

Introduction In Oracle APEX, interactive grids are essential for displaying and manipulating data in a dynamic and user-friendly manner. Recently, I developed a module for making quotations to customers, where the challenge was to modify an interactive grid using JavaScript. In this article, I’ll walk you through the steps to achieve this, showing how to

How to Modify Your Interactive Grid Using JavaScript in Oracle APEX Read More »

Enhancing Data Analysis with Select AI in Oracle APEX

Leave a Comment / Articles, Oracle APEX /

Enhancing Data Analysis with Select AI in Oracle APEX Introduction In today’s data-driven world, extracting meaningful insights from vast amounts of data can be a daunting task. Oracle APEX, a powerful low-code application platform, now integrates with Select AI to simplify this process. This blog post will walk you through the steps to set up

Enhancing Data Analysis with Select AI in Oracle APEX Read More »

Reconstructing Incomplete Shapefiles with Python

Leave a Comment / Articles, OCI Data Science /

Shapefiles are a common geospatial vector data format used in Geographic Information Systems (GIS) software. A complete shapefile dataset is composed of several files, each serving a specific purpose. However, sometimes users may encounter missing components in a shapefile dataset, leading to incomplete data representation. This article guides you through reconstructing missing shapefile components using

Reconstructing Incomplete Shapefiles with Python Read More »

Sign up
Sign up