Rutvik Prajapati's blog

Write

Improve Oracle APEX UX: Add a Top Horizontal Scrollbar to the Interactive Grid and Interactive Report

May 14, 20262 min read

SELECT AI Actions Explained: Same Prompt, Different Results

May 10, 202618 min read

SQLcl MCP Server: Bridging AI and Oracle Database

AI tools are becoming increasingly capable at generating SQL, explaining schemas, and even helping build applications. But without direct database context, LLMs still struggle to reliably understand r

May 15, 20266 min read

Setting up SELECT AI with External LLM Providers

May 9, 20268 min read

Setting up SELECT AI with OCI Generative AI on Oracle Autonomous Database

May 8, 20266 min read

Chat with Your Data: Getting Started with SELECT AI

Part 1 of the series SELECT AI in Practice

May 1, 20268 min read

Building Dynamic Navigation Menu in Oracle APEX

In APEX, Navigation Menu is basically a list component. You can create two types of lists: static and dynamic. In a Static List, entries are set up during design time in the APEX builder by using Create List Wizard and selecting Static List Type. On ...

Jan 7, 20264 min read

Why SQLcl Runs Your Script Twice: The "Slash" That Breaks Oracle APEX Deployments

Recently, I was working on a project where my responsibility was straightforward on paper: prepare a clean database installation script and hand it over to the DBA team for production deployment. The script included all the required database objects—...

Jan 2, 20265 min read

Oracle APEX Interactive Report: Download report on click of button #JoelKallmanDay

As we celebrate Joel Kallman Day 2025, we honor his legacy by learning, building, and sharing within the APEX community. This post is my small contribution to continue the spirit of collaboration Joel inspired in all of us. Interactive Reports in Ora...

Oct 15, 20252 min read

Oracle APEX and OCI Gen AI: Configure Generative AI Service for Smarter Apps

Before using AI-assisted development or creating AI-powered smart apps in APEX, the first step is to configure the Generative AI service in Oracle APEX to choose an AI provider. Generative AI Services

Mar 31, 20256 min read

Oracle APEX and OpenAI: Configure Generative AI Service for Smarter Apps

In this article, I'll walk you through the steps to use OpenAI AI service as the AI provider in Oracle APEX. This will enable AI-assisted development within the APEX builder to create smart AI applications. Step 1: Generate OpenAI API key To configur...

Mar 24, 20253 min read

Command Palette

Latest articles