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

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 Oracle APEX 21.2

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 …

Strip html using PLSQL

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, …

APEX_COLLECTION Using CREATE_COLLECTION_FROM_QUERY_B and CREATE_COLLECTION_FROM_QUERY_B2

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 …

APEX_JSON.WRITE_RAW

APEX_JSON write unescaped json write an unescaped array attribute. use the escaping write() procedures instead, if possible. PARAMETERS p_value The value to be written which can be longer than 32KB EXAMPLE Write an array attribute that contains JSON declare l_value apex_application_global.vc_arr2; begin l_value(1) …