Vikas Pandey Archives - Page 6 of 10

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(); $(…

Vikas Pandey August 14, 2021

PLSQL SQL

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…

Vikas Pandey August 6, 2021

APEX

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…

Vikas Pandey July 14, 2021

APEX

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.…

Vikas Pandey July 12, 2021

APEX

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…

Vikas Pandey July 9, 2021

ORACLE SQL

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…

Vikas Pandey June 9, 2021

APEX PLUGINS

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…

Vikas Pandey March 5, 2021

APEX IG Interactive Grid

2 ways to get total sum of Interactive Grid Column Oracle APEX

How to Calculate total sum of interactive grid column into page item in oracle APEX. Most of the time, this question was asked by my friends and colleagues that “How…

Vikas Pandey February 6, 2021

APEX

Creating a custom template Oracle APEX part-1

Creating a custom template. Templates are organized first by a template type and then by template class. Template types include page, region, report, list, button, label, and popup list of…

Vikas Pandey January 17, 2021