Ontoor blogs

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

ORDS

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

APEX Interactive Report JavaScript

Retrieving Values on Row Click in Oracle APEX Interactive Reports

Interactive reports serve as pivotal components in Oracle Application Express (APEX), offering users a dynamic platform to explore and interact with data. Implementing row click functionality allows users to extract…

Vikas Pandey May 11, 2024

APEX

Boosting Business Efficiency with Key Performance Indicators (KPIs) in Oracle APEX

In today's fast-paced business world, companies are working hard to keep up with the competition by keeping a close eye on how well they're doing compared to their goals and…

Ashish Sahay May 10, 2024

APEX IG Interactive Grid

Auto-Increment Line Numbers in Oracle APEX Interactive Grid on Add Row

Oracle APEX Interactive Grids offer a powerful and flexible way to interact with data. A common requirement is to have auto-incrementing line numbers for each row, particularly when adding new…

Vikas Pandey May 4, 2024

APEX IG Interactive Grid

Oracle APEX: Setting a Search Field in Interactive Grid from a Previous Page

Oracle APEX allows you to create interactive applications with powerful functionality. A common requirement is to set a search field in an Interactive Grid based on a value from a…

Vikas Pandey May 4, 2024

APEX IG Interactive Grid

Oracle APEX: Navigating to a Specific Column in Interactive Grid After Adding a New Row

Oracle APEX Interactive Grids allow users to manipulate and interact with data efficiently. A common requirement is to automatically navigate to a specific column when a new row is added.…

Vikas Pandey May 4, 2024