You can create an option in your Oracle Apex application to give the user an ability to select the theme of his choice at runtime. Below is a simple example. Follow these steps: 1. Create a Page in Oracle Apex…
In Oracle PL/SQL, to check if BLOB or CLOB is empty or not, use the dbms_lob.getlength() function or dbms_lob.compare() function. Here are the examples: 1. Using dbms_lob.getlength() Function declare vblob blob; Cursor c_blob is select content into vblob from employee_docs…
To auto-refresh, a report in Oracle Apex, use the setInterval() method to specify the interval in milliseconds and use jQuery to refresh the report region. The following are the steps: 1. Specify a Static ID for the interactive or classic…
In this tutorial, I am giving an example to handle errors at the page level in Oracle Apex. We handle the errors in Processing and in Validations, etc, but what if an unhandled error occurred? For example, a unique constraint…
In Oracle Apex, if you have created a dynamic action to set the value for multiple items, then at runtime, it will show the processing spinner on the right side. If it is for two or three items, then ok,…
In Oracle Apex, you will find the options where the SQL query source could be a Function Returning SQL Query or the PL/SQL Function Body Returning SQL Query for the items such as List, POPUP LOV, etc. And these options…
The following are some examples to show you how to loop through interactive grid records in Oracle Apex. To get interactive grid records using the JavaScript, first, we need to specify the Static ID for the interactive grid report. To…
In the previous tutorial, I have given an example to allow only integer value in a field using jQuery in Oracle Apex and in this tutorial, I will show you how to allow only numbers and decimal places (with one…
In this tutorial, I will show you how you can allow only integer value to be entered into a number field in Oracle Apex using the jQuery. Follow these steps: 1. Specify a Class for the Numeric Field In Oracle…
In Oracle Apex, you are trying to create a PL/SQL function body to return an SQL query, but you are getting the error ORA-20999: PL/SQL function body did not return a value. This is because you are definitely creating and…
In this tutorial, you will learn how to create dynamic action in Oracle Apex to execute JavaScript code. In the following example, I have two text fields on my page, one is a Value A and another is a Value…
In this tutorial, I will show you how to create an Incremental Search option for reports in Oracle Apex. Incremental search means, it starts searching as you type in the text input field. To create this feature in Oracle Apex,…
Here I am giving an example to create On/Off Toggle switch using HTML, CSS, and JavaScript in Oracle Apex. In this example, we will create a Toggle switch using HTML and CSS and will assign a value 'Y' if the…
In this tutorial, I will show you how to create tab pages in Oracle Apex. Every tab page in Oracle Apex is a separate region and when you place items in a specific tab, it will display when that tab…
In Oracle Apex, server-side conditions execute at the time of page initialization. You can use the server-side condition for objects such as items, regions, buttons, processes and for dynamic actions. If you have used applied a server-side condition, then the…
In this tutorial, you will learn how to create sticky buttons container region for dialog windows in Oracle Apex. Steps to Create Buttons Container in Oracle Apex Open the dialog page in Oracle Apex in which you want to add…
Sometimes it is required to refresh the whole page instead of refreshing a particular region. In this tutorial, I will show you how to reload/refresh the page using JavaScript in Oracle Apex. To do this on or after a particular…
In this tutorial, I will show you how to calculate field values using JavaScript in Oracle Apex. To perform this task, we will create a function in JavaScript so that we can call it from multiple fields and then populate…