In Oracle APEX, you can make interactive grid rows editable on condition. For example, you have a flag column APPROVED in your table, and if the APPROVED column value is N; a row can be edited else not. To do…

In Oracle APEX, use $x_Show() and $x_Hide() JavaScript API methods to show or hide DOM elements. A DOM element can be a region, button, page item, etc. But except page item, other elements such as regions and buttons must have…

In this tutorial, you will learn how to create a collection in Oracle APEX. This Oracle APEX collection example consists of the following topics: Creating a Collection in Oracle APEX Use apex_collection.create_collection method to create a collection. The following is…

In Oracle APEX, a shuttle item is a kind of list item having a multi-select option. It has two boxes (left and right) containing lists; the left side shows the source of the list and right side the selected values.…

In this tutorial, I will show you how to create a card layout report with images in Oracle APEX. By saying with images, I mean, we will create a card layout report based on a table having the BLOB column…

In this tutorial, you will learn how to get display value from the Select List in Oracle Apex. Usually, when we get the value using PL/SQL V() or binding methods (:), then we get the return value from the Select…

In Oracle Apex, you can check if an item value changed using the JavaScript API method isChanged(). The following is an example of it. Check/Determine if an Item Value Changed in Oracle Apex JavaScript method isChanged(), compares the current value…

In this tutorial, I am giving an example of just one line code to set an item value to the upper case in Oracle Apex. Sometimes it is required for an item to get input in the upper case and…

In Oracle Apex, you have created a modal dialog page and you want to disable the escape key to prevent close dialog window. To achieve this, follow these simple steps: Disable ESC Key to Prevent Close Dialog Open your dialog…

In this tutorial, I will show you how to create a dynamic action to submit a page in Oracle Apex. In Oracle Apex, when we create a button or a button created by itself using the wizard for a form,…

In Oracle Apex, we use client-side conditions with dynamic actions to perform a particular action if the client-side condition met and perform another action if the client-side condition does not match. And if your condition depends on multiple items, then…

In Oracle Apex, this is a general requirement to have a link in an interactive report for a particular column so that another page can be opened by passing some parameters to edit or view the records. You can create…

In Oracle Apex, if you are calling a page without clearing its cache, then you may notice that items have the values previously entered. I would recommend you should clear the cache when calling a page to make sure when…

Use apex.message.confirm() JavaScript method to display confirm dialogs in Oracle Apex. We use to display confirmation dialogs to ask for confirmation from the user to perform a particular action. For example, when the user clicks on the Delete button or…

In this tutorial, I will show you how to highlight the rows using the Highlight function from the Action menu at runtime. Highlighting Rows in Report Based on Condition in Oracle Apex To demonstrate this example, I am using the…

In this tutorial, I will show you how to install Oracle Apex 20.1 on Windows and Linux/Unix systems. Installing Oracle Apex 20.1 Installation of Oracle Apex 20.1 is the same as the prior versions, such as 19.1. But there is…

Oracle Apex 20.1 introduced new feature Automated Backups, and these backups are performed as part of daily maintenance. The only applications that have been modified will be backed up. To create an Automated Backup in Oracle Apex, follow these steps:…

Oracle Apex 20.1 introduced a new feature, Friendly URLs, and this means the URLs are now user and SEO (search engine optimization) friendly. The following are the simple steps to turn on this feature in Oracle Apex 20.1. Turn On…