Posted inAPEX JavaScript
Get Device ID in Oracle APEX
How to Get Device ID in Oracle APEX? Create a page with a page item and paste below Javascript in Function and Global Variable Declaration section as per screenshots. Copy CodeCopiedUse a…
Posted inAPEX JavaScript
javascript:apex.confirm In Oracle APEX
1. apex.page.confirm Signature 1. This example shows a confirmation dialog with the text ‘Delete Department’. If the user chooses to proceed with the delete, the current page is submitted with…
Posted inAPEX
Upload Multiple Files in Oracle APEX
How to upload multiple files in apex collection using Oracle APEX. Create a blank page where there will be a page item and a button as per screenshot. Create a…
Posted inAPEX JavaScript
Oracle APEX Javascript API
How to Set and Get Item Value Using Javascript In Oracle APEX? 1. Get Item Value In Oracle APEX Using Javascript API. Copy CodeCopiedUse a different Browserapex.item( "P6_NAME" ).getValue(); $(…
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
Disable Right Click and Copy Paste In Oracle APEX
Disable Right Click and Copy Paste In Oracle APEX. If you want to disable right click and Copy paste from your whole application then use below code globle page. Create…
Posted inAPEX
Order tracking progress bar in Oracle APEX
Order tracking progress bar in Oracle APEX. Create a blank page with select list item as per screenshot. Create region with region type plsql dynamic content and use below code.…
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…
APEX Camera Extension (ACE)
APEX Camera Extension (ACE) Plugin. APEX Camera Extension (ACE) plugin allows user to open Camera and and capture an image in APEX Collection. How to use? Steps: Download Plugin. Install…