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 set the Application header with text in ORACLE APEX? APEX 5 and APEX 18 In APEX 5 and APEX 18 we can only set up a logo or text at a time. So what if we need to display... 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
COALESCE return first not null value out all the parameter passed into this function. NOTE: All the parameters have be same datatype DROP TABLE coalesce_func_test; CREATE TABLE coalesce_func_test ( id NUMBER, col1 VARCHAR2 (10), col2 VARCHAR2 (10), col3 VARCHAR2 (10), col4 NUMBER... Read more
How to translate Oracle APEX into Multi-Languages? In application development, multilanguage translation is always a tedious job to accomplish. But when it comes to APEX is just like a couple of steps. Found Interesting? Let’s see….. How to pass the... Read more
NULL in Oracle NULL = NULL ? NULL_ NULL is NOT Equals to NULL COUNT with NULLs COUNT(A) 2 SUM with NULLs SUM(A) 12 LENGTH with NULLs SELECT LENGTH (NULL) len, 'LENGTH' FROM DUAL; LEN ‘LENGTH’ LENGTH Order by with... Read more
What is cursor: Pointer to the memory location where the information about sql stmt or DML statement got executed. There are two types of cursors − Implicit Cursor:= Any Select Stmt Or Any SQL Stmt Executed By Oracle Is Through Cursor And... Read more
How to select all records in Interactive Report without any limitation Oracle APEX This approach can be used in case of when a single pagination has more than 50 records. <input type="checkbox" id="selectunselectall"> Name Select all Event Change Selection Type... 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