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

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

Interactive GRID Appearance CSS Classes - ig-windows-style Page Inline CSS .ig-windows-style .a-GV-table .a-GV-cell, .ig-windows-style .a-GV-table .a-GV-controlBreakHeader { border-color: transparent; } .ig-windows-style .a-GV-w-frozen .a-GV-table { border-right: none; } .ig-windows-style .a-GV-table tr.is-hover …