Interactive Grid intrdoduction| Ontoor Concepts #1 In this Short Video Ashish has given the brief intrdoduction of Interactive GRID. Interactive Grid concepts. Why do we need Grid? How to create an interactive Grid? Data Sources Grid action Menu How to Make Interactive Grid Editable? Authorization on DML Row Locking …

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 …

Application Process | Ontoor Shorts #6 In this Short Video Vikas has explained, how can we create and use Application Process.

APEX Friendly URL | Ontoor Shorts #7 In this Short Video Vikas has explained, how can we convert Application URL into Friendly URL.

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 …

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 …

How to Store Data in Web Browser Storage - localStorage and sessionStorage. The main difference between sessionStorage and localStorage is that sessionStorage only maintains a storage area while the browser is open (including when the page reloads or restores) while localStorage continues to store data after the …

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 …

APEX Login Page Region Icon/Image | Ontoor Shorts #5 In this Short Video Vikas has explained, how can we change the APEX login region image/icon.

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 …

APEX Login Page Templates | Ontoor Shorts #4 In this Short Video Vikas has explained, how can we customize the APEX login page template using APEX declarative templates options.

APEX application Header Logo | Ontoor Shorts #3 In this Short Video Vikas has explained, how can we setup the APEX application header image. Availble Options Text Image Image and Text both