3 ways to find second highest salary ORACLE SQL
Solution 1 : Copy CodeCopiedUse a different BrowserWITH t AS (SELECT sal, ename, DENSE_RANK () OVER (ORDER BY sal DESC) AS rnk FROM emp) SELECT sal, ename FROM t WHERE…
Posted inAPEX
Display Image from Directory in ORACLE APEX
Display Image from Directory in ORACLE APEX. One of my colleague had asked to me, How can i display image in Interactive/Classic Report or Interactive Grid from Directory without storing…
10 ways get Distinct/Unique record without using DISTINCT Oracle
How to get Distinct/Unique record without using DISTINCT SQL/Oracle? Create table using following script: Copy CodeCopiedUse a different BrowserCREATE TABLE test_emp ( ename VARCHAR2 (10 BYTE), deptno NUMBER (2), id…
Posted inAPEX
LAZY Loading Oracle APEX
Lazy Loading Specify whether to load the region independently of the data for the region. When lazy loading is specified, the page is rendered immediately, showing an empty region, until…
Table Blob to Oracle Directory
How to save table images to oracle directory? Files from table to Oracle directory Copy CodeCopiedUse a different BrowserDECLARE l_file UTL_FILE.file_type; l_buffer RAW (32767); l_amount BINARY_INTEGER := 32767; l_position INTEGER…
Posted inORACLE
Oracle NULLIF() Function
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…
Posted inORACLE
3 Ways to Delete Duplicate Record From table in Oracle
How to delete duplicate record From table using SQL/Oracle? Create table using following script: Copy CodeCopiedUse a different BrowserCREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER )…
Posted inORACLE
3 Ways to Check Duplicate Record in table Oracle SQL
How to check duplicate record in table SQL/Oracle? Create table using following script: Copy CodeCopiedUse a different BrowserCREATE TABLE TEST_EMP ( ENAME VARCHAR2(10 BYTE), DEPTNO NUMBER(2), ID NUMBER ) Run…
Posted inORACLE
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…
Oracle NULL-Related Functions
Oracle NULL-Related Functions. There are different type of null related function in oracle. NVL NVL function will check whether the first input parameter is null, if its null value, it…