3 Ways to Delete Duplicate Record From table in Oracle

How to delete duplicate record From table using SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more

3 Ways to Check Duplicate Record in table Oracle SQL

How to check duplicate record in table SQL/Oracle? Solution 1 : Solution 2 : Solution 3 : You might also like Read more

Oracle NVL2 Function

Oracle NVL2 Function: NVL2() function is an extend version of the NVL() function with different options based on whether a NULL value exists. Oracle NVL2() function allow three parameters. If the first parameter is not null, then it returns the... Read more

Oracle NULL-Related Functions

Oracle NULL-Related Functions. There are different type of null related function in oracle. Read more

Oracle NVL Function

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

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

Application header with text in ORACLE APEX

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

3 Ways to Unselect Default Checkbox in Interactive Grid Oracle APEX

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

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 in oracle

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