Oracle Archives - Ontoor blogs

Store and Access Files in OCI Bucket Using DBMS_CLOUD in Oracle APEX

Storing and Accessing Files in OCI Bucket Using PL/SQL for Oracle APEXStoring and Accessing Files in OCI Bucket Using PL/SQL for Oracle APEX In our previous blog we have seen…

Ashish Sahay May 28, 2025

ORACLE_FORMS

Oracle Forms to APEX Migrations

Why Do We Need It? For several years, Oracle Forms has been a stable choice for enterprise application development. Over the years, driven by user demand, these forms can no…

Ashish Sahay June 27, 2024

APEX Interactive Report JavaScript

Retrieving Values on Row Click in Oracle APEX Interactive Reports

Interactive reports serve as pivotal components in Oracle Application Express (APEX), offering users a dynamic platform to explore and interact with data. Implementing row click functionality allows users to extract…

Vikas Pandey May 11, 2024

JavaScript JS_API

Dynamic Action Success Message Oracle APEX

This function displays a page-level success message. This clears any previous success messages displayed and also assumes there are no errors and clears errors previously displayed. Success messages display using…

Vikas Pandey January 16, 2024

APEX

Column Group in Oracle APEX

In Oracle APEX, a column group is a way to organize and manage columns in a report region. It allows you to group related columns together and apply certain settings…

Vikas Pandey December 28, 2023

ORACLE SQL

How to find ORACLE locked Objects?

Copy CodeCopiedUse a different BrowserSELECT a.osuser, a.sid, b.os_user_name, b.oracle_username, b.session_id, c.object_name, c.object_type FROM v$session a, v$locked_object b, dba_objects c WHERE a.sid = b.session_id AND b.object_id = c.object_id AND c.object_name =…

Ashish Sahay September 21, 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

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

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…

Vikas Pandey October 3, 2020