The NVL function allows you to replace null values with a default values. If the first parameter is null, the function returns the second parameter. If the first parameter has some value then always return the first value. Note:= NVL... Read more
Oracle DECODE() function compares the first argument with the second argument. If they are equal, the function returns the third argument otherwise returns the default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: SELECT DECODE (1,... Read more
How to Unselect Default Checkbox in Interactiv Grid Oracle APEX? In some situation we don’t want default checkbox selection in Interactive Grid on those cases, there are 3 ways to unselect default checkbox from Interactive grid using jquery. Solution: 1 Solution: 2... Read more
3 ways to Add Custom Button In Interactive Grid Oracle APEX? Now there are 3 ways to create custom Add, Edit, Save, and Delete buttons for an Interactive Grid in Oracle APEX and all these buttons will execute the JavaScript code to... Read more
Sometimes user wants to prevent duplicate row on that column where columns don’t have a unique Id or Primary key Identification. On those cases here, I have provided a solution which will definitely help you. Demo You might Like Read more
SOLUTION 1: Column Formatting => HTML Expression: <span style="white-space:nowrap;">#COLUMN_NAME#</span> SOLUTION 2: Define region Id “regionId” and Column id “HIRE_ID” after that use following CSS: #regionId th#HIRE_ID, #regionId td[headers=HIRE_ID]{min-width:100px} Read more
Sometimes we face the requirement like how to show the image before image upload. There are some easy steps to preview images before upload. Demo You might like: Read more
SELECT REGEXP_REPLACE('Sahay*)(^#@Pandey$ashish/Vikas','[^a-z_A-Z ]') FROM DUAL; You might Like How to Remove New line from a String Using PL/SQL/ORACLE Read more
In this article, you can learn how to open an inline modal dialog in Oracle Apex. There are different ways to open modal dialog using simple JQuery. Inline modal dialog helps us in critical situations such as showing an error... Read more