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 …

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

APEX APIs

List of APEX APIs APEX_COLLECTION APEX_AUTOMATION APEX_CSS APEX_DATA_EXPORT APEX_DATA_PARSER APEX_DEBUG APEX_ESCAPE APEX_EXPORT APEX_IG APEX_IR APEX_ITEM APEX_JAVASCRIPT APEX_JSON APEX_LANG APEX_LDAP APEX_MAIL APEX_PAGE APEX_SESSION APEX_STRING APEX_WEB_SERVICE APEX_ZIP

JSON_TABLE

JSON_TABLE Data retrievable / parsing using JSON_TABLE SELECT jt.* FROM json_table('JSON STRING', '$' COLUMNS ( "COLUMN_NAME" VARCHAR2(4000) PATH '$.JSON_KEY' .... .... , NESTED PATH '$.nested_array[*]' COLUMNS ( COL01 NUMBER PATH '$.COL01_PATH', COL02 VARCHAR(4000) PATH …