Ontoor blogs

Horizontal Scrollbar On Top of Interactive Grid Oracle APEX

When working with Oracle APEX Interactive Grids, horizontal scrolling can be crucial for navigating wide datasets. While these grids typically have a horizontal scrollbar at the bottom, adding one to…

Vikas Pandey April 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 IG Interactive Grid

Customizing the Oracle APEX Interactive Grid Toolbar: Adding a “Rows Per Page” Selector with a Static Label

Oracle APEX Interactive Grids offer a flexible way to manage and display data. A common customization is adding a "Rows Per Page" selector to the toolbar, allowing users to adjust…

Vikas Pandey April 13, 2024

IG Interactive Grid

Interactive Grid in Oracle APEX

Creating Interactive Grids in Oracle APEX Oracle APEX offers powerful tools for developing web applications, and one of its key components is the Interactive Grid. Interactive Grids provide users with…

Ashish Sahay April 12, 2024

APEX_AUTOMATION

APEX_AUTOMATION in oracle APEX

APEX_AUTOMATION is a shared component feature that helps developers automate activities and tasks. It can trigger itself automatically at a specific time and event. These events could be yearly, monthly,…

Ashish Sahay April 11, 2024

APEX Interactive Grid

How to Enable Edit Mode on Page Load with Dynamic Actions in Oracle APEX Interactive Grids

In Oracle APEX, dynamic actions offer a flexible way to execute code in response to events. To automatically activate "edit" mode in an Interactive Grid upon page load, you can…

Vikas Pandey March 9, 2024

APEX Interactive Grid JavaScript

Hiding Default Toolbar Buttons in Oracle APEX Interactive Grids

Oracle APEX Interactive Grids are highly flexible for managing data, but sometimes you need to customize the toolbar by hiding default buttons like "Edit," "Save," or "Add Row." This can…

Vikas Pandey February 29, 2024

Reporting

Reporting and printing in Oracle APEX

Oracle APEX offers several ways to generate reports and print them or export them to different file formats. Here's a summary: Built-in PDF and Excel Download: You can configure classic…

Ashish Sahay February 24, 2024

APEX

Interactive Grid (IG) disable warn on unsaved changes

How to Remove the Default Alert for Unsaved Changes in Oracle APEX Interactive Grids? This article outlines a method to remove the default alert for unsaved changes in Oracle APEX…

Vikas Pandey February 23, 2024

Interactive Grid JavaScript

Add Row | Focus column- gotoCell | Interactive Grid

Create a Dynamic Action: Create a Dynamic Action with the following settings: Event: Selection Change{IG} Selection Type: Execute JavaScript Code Copy CodeCopiedUse a different Browserapex.jQuery(document).ready(function() { // Get the Interactive…

Vikas Pandey January 21, 2024