Ontoor blogs

Oracle REST API on top of Oracle Autonomous Database for Modern-Day Applications

In today's fast-paced digital world, businesses need agile, scalable, and efficient solutions to manage and leverage their data. Oracle REST Data Services (ORDS) on top of Oracle Autonomous Database (ADB)…

Ashish Sahay July 2, 2024

ORACLE_FORMS

Oracle Forms to APEX Migrations

Why Do We Need It? For several years, Oracle Forms has been a stable choice for enterprise application development. Over the years, driven by user demand, these forms can no…

Ashish Sahay June 27, 2024

OCI

Moving On-premise Oracle Database and Oracle APEX to Oracle Cloud Infrastructure (OCI)

Modernize Your Oracle Workloads in the Cloud In the modern business world, many groups see the big pluses of moving their Oracle Database and Oracle APEX to the cloud. Oracle…

Ashish Sahay April 26, 2024

Interactive Grid JavaScript JS_API

Implementing Row ID Capture into Page Items in Oracle APEX Interactive Grids

Introduction Capturing selected row IDs in Oracle APEX Interactive Grids is essential for many dynamic applications where developers must perform batch operations, updates, or any processing based on user-selected records.…

Vikas Pandey December 25, 2024

APEX

Eliminating Redundant Success Messages on Page Refresh

In this brief guide, we’ll cover how to prevent success messages from reappearing each time a user refreshes the page. Understanding the Issue For those using an older version of…

Vikas Pandey September 22, 2024

APEX IG Interactive Grid

Improving Data Accuracy: Custom Validation Strategies for Oracle APEX Interactive Grids

Oracle APEX offers a powerful platform for building dynamic web applications, and the Interactive Grid is one of its most flexible components. Ensuring data integrity within Interactive Grids is crucial…

Vikas Pandey September 15, 2024

APEX Interactive Grid JavaScript

Streamlining Data Downloads in Oracle APEX Interactive Grids: A Professional Guide

A common requirement for many applications is to offer users the ability to download grid data in various formats. This blog will guide you through customizing download functionalities for an…

Vikas Pandey September 7, 2024

APEX Interactive Grid

Customizing Interactive Grid Toolbars: How to Hide the Toolbar Button in Oracle APEX

Interactive Grids (IGs) in Oracle APEX provide a robust and flexible way to manage and edit data. However, there may be situations where you want to customize the toolbar to…

Vikas Pandey September 7, 2024

APEX Interactive Grid JavaScript

Improve User Experience with Dynamic Column Tooltips in Oracle APEX Interactive Grids

In this article, we'll guide you through adding dynamic tooltips to Interactive Grid (IG) headers in Oracle APEX, utilizing a lookup table for flexibility and customization. This feature improves user…

Vikas Pandey August 31, 2024

PLSQL SQL

Advanced SQL Query Validation: Ensuring Integrity with PL/SQL

In today's data-driven world, ensuring the accuracy and integrity of SQL queries is paramount. Invalid queries can lead to errors, performance issues, and data inconsistencies. This blog will deep into…

Vikas Pandey August 30, 2024

APEX Interactive Grid JavaScript

Advanced-Data Processing in Oracle APEX: Interactive Grid to Collection

This blog will guide you through efficiently managing selected records from an Oracle APEX Interactive Grid. We’ll focus on capturing these selected records and inserting them into APEX collections. APEX…

Vikas Pandey August 24, 2024

APEX

Reflow Report in Oracle APEX

In my older article, to achieve the reflow behaviour I had to customize the template to create a Responsive Classic Report. Now we have the declarative region type dedicated to…

Ashish Sahay August 13, 2024

APEX

Efficiently File Download in Oracle APEX | Ontoor Solutions

Oracle APEX provides many ways to download a file from the database. Each and every method is declarative and easy to implement. Whether you’re managing reports, generating dynamic content, or…

Ashish Sahay August 11, 2024