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 https://youtu.be/VqggHl6mJdw
APEX Dialog Page drawers | Ontoor Shorts #2
In this Short Video Ashish has explained, how can we create drawer effect in APEX dialog pages. Available Options for Inline regions and Dialog Pages DRAWERS from left DRAWERS from Right https://youtu.be/lV-LSlnnG-Y
Posted inAPEX APEX Hours
Ontoor APEX HOURS 01 (APEX 21.2 What’s new)
Walking through APEX 21.2 new features. https://youtu.be/sWDLyuUahlE Powerful Search Bar Search Suggestions Suggestion Chips Progressive Web Apps Greater Flexibility in Page Layouts Modal Dialog Drawers Updated Alert and Confirm Dialogs…
Posted inAPEX
What’s New in Oracle APEX 21.2- Improved Editors
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…
Posted inAPEX
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:…
Posted inAPEX IG Interactive Grid
Interactive GRID | Custom Progress on Loading Data
Referred from John’s cookbook sample app. Execute when Page Loads // Add the progress indicator. An alternative would be to add this to a page template. $("#t_Header .t-Header-logo").append('<div id="progress" class="progress-bar stripes"><span></span></div>'); Interactive…
Posted inAPEX IG Interactive Grid
Interactive GRID | Dynamic Column Total
Referred from John’s cookbook sample app. Interactive GRID Static ID - emp Grid Query SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM FROM emp Function and Global Variable Declaration Copy CodeCopiedUse a…
Posted inAPEX IG Interactive Grid
Interactive GRID | Nested Table In Cell
Referred from John’s cookbook sample app. Inline css .gv-nested-tbl { border-collapse: collapse; width: 100%; } .gv-nested-tbl td, .gv-nested-tbl th { border: 1px solid #EAEAEA; } .a-GV-row { height: 50px; } Interactive Grid…
Posted inAPEX Interactive Grid
Interactive GRID | Windows List View Style – Checkbox visible on hover
Referred from John’s cookbook sample app. Interactive GRID Appearance CSS Classes - ig-windows-style Page Inline CSS Copy CodeCopiedUse a different Browser.ig-windows-style .a-GV-table .a-GV-cell, .ig-windows-style .a-GV-table .a-GV-controlBreakHeader { border-color: transparent; } .ig-windows-style .a-GV-w-frozen…
Posted inAPEX
Strip html using PLSQL
Referred from John’s cookbook sample app. Copy CodeCopiedUse a different Browsercreate 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…