How to Store document in OS file instead of database in Oracle Apex

Store, Preview & download attachment from OS File instead of Database Table Click to download the details PDF document of this topic Let us take a look the Final view of the Work done: Step-1: Create and grant permission of Oracle Directory to Schema Login to the database using SYS …

Query of Calculating Second highest value

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

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

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 …