Dialog Page drawer in Oracle APEX

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 …

Closing Browser upon Logging out In Oracle APEX

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 …

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 …