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

APEX APEX_JSON IG

Efficiently Handling Interactive Grid to Collection: Filtered, Unfiltered and Updated Records

This article explores a solution for managing all records in an Interactive Grid, whether filtered or not, and inserting/updating them into APEX collections for subsequent processing. In contrast to a…

Vikas Pandey September 29, 2024

APEX IG Interactive Grid

Implementing Duplicate Validation in Oracle APEX Interactive Grids

Maintaining accurate data is vital in any application, particularly with databases. Duplicate entries can create confusion and hinder productivity. This article presents two straightforward methods for validating duplicates in Oracle…

Vikas Pandey September 22, 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