Data loading utility in Oracle APEX
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:…
October 11, 2021
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…
October 7, 2021
Posted inAPEX IG Interactive Grid

Interactive GRID | Hide Report Settings Area

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { config.reportSettingsArea = false; apex.util.getNestedObject(config, "views.grid.features").highlight = false; return config; }
October 6, 2021
Posted inAPEX Interactive Grid

Interactive GRID | Rows Per Page on Toolbar

Referred from John’s cookbook sample app. Interactive GRID Attributes Advanced JavaScript Initialization Code Copy CodeCopiedUse a different Browserfunction(config) { var $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(), toolbarGroup = toolbarData.toolbarFind("actions1"); toolbarGroup.controls.unshift( { type:…
October 6, 2021