How to delete duplicate record From table using SQL/Oracle? Create table using following script: 1CREATE TABLE TEST_EMP 2( 3 ENAME VARCHAR2(10 BYTE), 4 DEPTNO NUMBER(2), 5 ID NUMBER 6) Run following script for demo purpose. 1SET DEFINE OFF; 2Insert into TEST_EMP (ENAME, DEPTNO, ID) 3 Values ('SMITH', 20, …

Read More

Oracle NULLIF() Function: The Oracle NULLIF() function accepts only two arguments. If the both arguments are equal it returns a null value. In case the arguments are not equal, the NULLIF() function returns the first argument and if any arguments will null then function return an error. Syntax of the NULLIF() …

Read More

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 second parameter. In case the second parameter is null, then it returns the …

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 return default value. The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement: 1SELECT DECODE (1, 1, 'ONE', …

Read More

Oracle NVL Function: The NVL function allow you to replace null values with a default value. If the first parameter is null, the function returns the second parameter. If the first parameter have some value then always return first value. Note := NVL function replaces null value with same type data. Syntax of the …

Read More

Oracle NULL-Related Functions. There are different type of null related function in oracle. NVL 1NVL function will check whether the first input parameter is null, if its null value, 2 it returns the second parameter value. DECODE 1The Oracle/PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement. …

Read More

How to set the Application header with text in ORACLE APEX? We have been asked about setting up the Application logo with the text string. Let’s take a look version by version. 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 text and logo …

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. Create an Interactive grid and define region Id ontoor. To demonstrate …

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 perform Add, Edit, Save, and Delete row functions. But the question is that why we …

Read More