JSON_MERGEPATCH function is very useful to update JSON nodes in JSON document. We can simply pass the JSON required JSON patch to merge with existing JSON document using JSON_MERGEPATCH function, it can add or update the JSON node as per the availbility of nodein JSON document. Oracle Document link Create a table with …

APEX Font Toggler (AFT) Plugin. APEX Font Toggler (AFT) plugin allow users to increase or decrease application font size at their convenience and this plugin is free for use under MIT license. How to use? Steps: Download Plugin. Install this plugin into your application. Create a page region, template as blank with …

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 this plugin into your application. Create a page region with button. Create a dynamic action on button. Create True action. Choose …

Print Preview Region into PDF Plugin in Oracle APEX This plugin is updated version 2.0 of old plugin v1.0 which converts your APEX region data or report data into pdf format. Now the change is it will also support open print preview and APEX chart instead of download. For better understanding please look at the …

Render Apex Region to Navigation Menu in Oracle APEX version 1.0 This Plugin will render or move the apex region to the navigation menu, for that first create a region then create dynamic action on page load and Choose that region on the affected element. You Must have to choose region template Blank with attributes. …

How to Print apex region into PDF format in Oracle APEX? The answer… People typically want to download region into pdf format from a Classic Report, Interactive Report, or plsql dynamic content and this plugin will not supportable for chart and graph. If you need print preview and also support graph, bar chart …

Move APEX page item to navigation menu, navigation bar or Application title. This plugin help to move the page items to navigation menu, Navigation bar or Application title. Steps Download Plugin from apex.world Install to your application Create page Item in your application. Create Dynamic action on load …

Material Cards Region plugin (1.0) | Oracle APEX. This plugin returns the dynamic material cards with ripple effect. In this plugin everything is customizable, from color to icons and even number of cards per row. Steps Download Plugin Install to your application Create a region in your application page. write your …

In APEX interactive reports when we switch the report view from table view to row view, we use to see too much lag and screen loading. like below… It might impact user experience, sometimes report may have too much data and as a developer, we should not allow any extra query loading time. To avoid this problem I …

The social footer is one of my plugins. I have created this plugin to avoid writing code over and over and static codes in HTML for showing social icons or social footer. This plugin allows the developer to provide the query, which can use to fetch icons, label text. configuration option to setup color. Query …

Accordian Report is a great interface when you want to utilize the screen space. I took the references from the Accrodian library and used to implement it in Oracle APEX. Steps Download Plugin Install to your application Create a region in your application page. write your query as below Select initcap(ename) TITLE, …

APEX user profile utility This plugin is inspired by the APEX workspace user profile option. Steps Download Plugin Install to your application Create Dynamic action on load Add true action Setup profile panel JSON Create triggering Element: Trigger Element ID- eg. open-apex-profile Define SQL Source Escape Special …