April 2019 – Explore the world of amazing APEX

Apex Explorer April 13, 2019 May 24, 2022 Apex

Query of finding number of duplicate rows

Run the below SQL Statement to find the number of duplicate rows:

Select DEPTNO,count(*) from EMP
group by DEPTNO having count(*) > 1

1 2	Select DEPTNO,count() from EMP group by DEPTNO having count() > 1

Thank You

Apex Explorer April 13, 2019 May 24, 2022 Apex

Query of Calculating Second highest value

Run the below SQL query to generate any level of highest value to calculate:

SELECT 
      MAX(sal) AS salary 
FROM 
      emp 
WHERE 
      deptno = 10 and 
      level = 2  /* change this value to find nth maximum salary */
CONNECT BY 
      prior sal > sal 
GROUP BY 
      level 
ORDER BY 
      level

1

2

3

4

5

6

7

8

9

10

11

12

13

SELECT

MAX(sal) AS salary

FROM

emp

WHERE

deptno = 10 and

level = 2 /* change this value to find nth maximum salary */

CONNECT BY

prior sal > sal

GROUP BY

level

ORDER BY

level

In the above query statement, just change the Level = 2, 3,4…etc to find the nth position of maximum value. Thank You

Apex Explorer April 13, 2019 May 24, 2022 Apex

Open popup window and pass value using JavaScript in oracle apex

Open Pop-up window and Pass parameter value in Oracle Apex using JavaScript & AJAX Steps: Create 2 pages Page_1: Name = Master page, In this Page simply create a Text Field : P1_ITEM, Button: BUTTON_OPEN_POPUP Page_2: Name = Pop-up Page, In this Page simply create a Text Field: P2_PARAM Create …