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 …

Oracle APEX Dynamic Navigation Menu : Ontoor Extras In this Video Vikas has explained, how can we create Dynamic Navigation Menu in Oracle APEX using custom table. How to Create Dynamic Navigation Menu in Oracle APEX https://blogs.ontoorsolutions.com https://apex.ontoorsoltions.com https://apps.ontoorsolutions.com …

Ajax Callback/ On-Demand : Run this application process when requested by page Process. If you create an Ajax Callback/On-Demand process that dynamically shows the values of another item without submitting the page. To create an application process : Navigate to the Shared Components page: Under Application Logic, …

Understanding application process and it’s usage. Application Processes run PL/SQL logic at specific points for each page in an application or as defined by the conditions under which they are set to fire. 1. On Load: Before Header (page template header) 2. On Load: After Header (page template header) 3. On Load: …

APEX_DATA_PARSER performance issues. In my previous blogs , we have seen how easy is to parse the excel and CSV files using APEX_DATA_PARSER. All options are declarative and easy to use. I have been using this utility for a long time but the use involved with small files. Recently I needed to process and parse a file …

How to Create Dialog Page drawer in Oracle APEX. Create a page as a Modal Dialog in which set Dialog Template => Drawer as per screenshot. In Templates Options for Modal Dialog Drawer Page. DRAWERS from left DRAWERS from Right Now you can direcly navigate on drawer page from another page as per Screenshot. You …

How to Close Browser upon Logging out In Oracle APEX. Solution 1: In the shared components section go to the Navigation bar and click on the Logout link. Paste Below code as per screenshot. javascript:window.top.close(); Solution 2: Create a logout named function in global page/zero page to logging out from the …

Faceted Search V/S Smart Filters at a glance | Ontoor APEX Hours #2 Comparison between Faceted search and Smart filter regions Oracle APEX. Smart Filters:- Smart Filters is a new search component that allows users to quickly narrow data down with filters suggestions or search terms. Developers can use this component …

Ontoor APEX HOURS 01 (APEX 21.2 What’s new) Walking through APEX 21.2 new features. Powerful Search Bar Search Suggestions Suggestion Chips Progressive Web Apps Greater Flexibility in Page Layouts Modal Dialog Drawers Updated Alert and Confirm Dialogs Display Mini Maps https://blogs.ontoorsolutions.com …

What’s New in Orale APEX 21.2 ? APEX 21.2 is live apex.oracle.com , thanks to APEX DEV team. APEX 21.2 comes up with enormous updates including Smart filters Progressive Web Apps, Universal Theme & UI Updates, new components and updated components. Let’s see what we got in this release? New positions In …

Oracle APEX 21.2 Improved Editor Static File Editor For static file editing, I have been using FOEX chrome extension till date. Now editing is allowed within the designer natively. Allows developers to create, edit and rename static application, workspace, plug-in, and theme files without the need to re-upload the …

APEX 21.2 New JavaScript APIs Stefan’s Blog John’s BLog Daniel’s Blog apex.env apex.env; apex.date Daniel’s Blog apex.regions apex.regions.emp.refresh(); OR apex.region("emp").refresh(); apex.items //Snippet from Stefan's Blog // getting an item’s value: var sal = …

Data Loading Utility in Oracle APEX COLLECTION Step 1: Create Data Loading Definition Step 2: Select Target Type (COLLECTION Name- DATA_LOADING) Step 3: Sample Data Mapping (Source Type - Upload a File/Copy and Paste) Step 4: File Size and Data definition selection Step 5: Create a page using the Data Definition for …

create or replace function striphtml( p_html in varchar2) return varchar2 is l_html varchar2(32767); l_pos pls_integer; begin if length(p_html) > 0 then l_html := p_html; loop l_pos := regexp_instr(l_html, '<[^<>]*>'); if l_pos > 0 then l_html := regexp_replace(l_html, …

CREATE_COLLECTION_FROM_QUERY_B Procedure Use this procedure to create a collection from a supplied query using bulk operations. This method offers significantly faster performance than the CREATE_COLLECTION_FROM_QUERY method. The query is parsed as the application owner. If a collection exists with the same name for …