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

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

First Day of the YEAR by ROUND function This function works similar to ROUND of numbers, if the month is geater than six (6) then return the day of next year else it returns day of current year. SELECT ROUND (SYSDATE, 'YEAR') "As of day" FROM DUAL; / AS OF DAY 1/1/2021 SELECT ROUND (TO_DATE …

BULK Return from FORALL insert. CREATE TABLE ashish_bulk_ret ( id NUMBER GENERATED AS IDENTITY PRIMARY KEY, name VARCHAR2 (31) ); DECLARE TYPE l_rec_typ IS RECORD ( id NUMBER, name VARCHAR2 (32) ); TYPE l_ret_list_tbl_typ IS TABLE OF l_rec_typ; l_ret_list_tbl l_ret_list_tbl_typ; TYPE l_data_rec_typ IS RECORD (name …

Download files in APEX shorcode. begin sys.htp.init; sys.owa_util.mime_header( <MIME_TYPE>, FALSE ); sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( <BLOB_FILE>)); sys.htp.p('Content-Disposition: attachment; filename="' || <FILE_NAME> || '"' ); …

How to generate DDL of any object in ORACLE? SELECT DBMS_METADATA.get_ddl ( <OBJECT_TYPE>, <OBJECT_NAME>, <SCHEMA_NAME>) FROM DUAL;

How to upload Multiple files in APEX? declare l_file_names apex_t_varchar2; l_file apex_application_temp_files%rowtype; begin l_file_names := apex_string.split ( p_str => :page item name, p_sep => ':' ); for i in 1 .. l_file_names.count loop select * into l_file from apex_application_temp_files where name …

How to reorder ORACLE table columns? Sample table CREATE TABLE TEST_COLUMN ( ID NUMBER, NAME VARCHAR2(200) CREATED_BY VARCHAR2(50) ); Add a column ALTER TABLE TEST_COLUMN ADD EMAIL VARCHAR2(50); Column Order will be ID NAME CREATED_BY EMAIL Reorder Email next to NAME. ALTER TABLE TEST_COLUMN MODIFY CREATED_BY …

How to find lock Object in ORACLE. SELECT a.osuser, a.sid, b.os_user_name, b.oracle_username, b.session_id, c.object_name, c.object_type FROM v$session a, v$locked_object b, dba_objects c WHERE a.sid = b.session_id AND b.object_id = c.object_id AND c.object_name = UPPER ('TABLE_NAME');

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

Oracle Application Express JavaScript API Reference Widgets grid iconList interactiveGrid menu menuButton recordView tableModelView tableModelViewBase treeView Usefull Namespaces apex

Working with APEX? You should use the below Themes, Tools and Bolilerplates. Themes Universal Theme - Official Theme shipped with APEX > 5.0 - by Oracle APEX Development Team Material APEX - Material Design Theme - by Vincent Morneau Font APEX - Icon Pack shipped with APEX 5.1 Tools APEX Nitro - essential APEX …

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 …

How to Set and Get Item Value Using Javascript In Oracle APEX? 1. Get Item Value In Oracle APEX Using Javascript API. apex.item( "P6_NAME" ).getValue(); $( "#P6_NAME" ).val(); $v( "P6_NAME" ); $x("P6_NAME").value; 2. Set Item Value In Oracle APEX Using Javascript API. apex.item( …