Ontoor APEX HOURS 01 (APEX 21.2 What’s new)

Walking through APEX 21.2 new features. https://blogs.ontoorsolutions.com  https://ontoorsolutions.com  https://www.apexd2d.net Read more

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 rename static application, workspace, plug-in, and theme files without the... Read more

Data loading utility in Oracle APEX

COLLECTION Sample Data Loading into Table Create a table for loading data. Demo #JoelKallmanDay  Read more

Interactive GRID | Custom Progress on Loading Data

Referred from John’s cookbook sample app. // 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>'); Read more

Interactive GRID | Dynamic Column Total

Referred from John’s cookbook sample app. SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM FROM emp Read more

Interactive GRID | Nested Table In Cell

Referred from John’s cookbook sample app. .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; } <table class='gv-nested-tbl'><thead><tr><th colspan=3>Country</th></tr><tr><th>Born</th><th>Died</th><th>Age</th></tr></thead></table> <table class='gv-nested-tbl'><tbody><tr><td colspan=3>&COUNTRY.</td></tr><tr><td>&FROM_YR.</td><td>&TO_YR.</td><td>&AGE.</td></tr></tbody></table> NOTE: Use COUNTRY, FROM_YR, TO_YR and AGE are... Read more

Interactive GRID | Windows List View Style – Checkbox visible on hover

Referred from John’s cookbook sample app. Referenced/Copied from John’s Cookbook We can refer above CSS snippet for other CSS tricks in GRID. Read more

Strip html using PLSQL

Referred from John’s cookbook sample app. Strip Plane Hello <h1> Hello</h1> Updates on 7th January 2023 APEX has added this as a new feature by adding this as function into APEX_ESCAPE API. Read more

Interactive GRID | Hide Report Settings Area

Referred from John’s cookbook sample app. Read more

Interactive GRID | Rows Per Page on Toolbar

Referred from John’s cookbook sample app. Read more