APEX 21.2 New JavaScript APIs Stefan’s Blog John’s BLog Daniel’s Blog apex.env apex.env; apex.date Daniel’s Blog apex.regions apex.regions.emp.refresh(); OR apex.region("emp").refresh(); apex.items //Snippet from Stefan's Blog // getting an item’s value: var sal = …

Oracle APEX 21.2 Improved Editor Static File Editor For static file editing, I have been using FOEX chrome extension till date. Now editing is allowed within the designer natively. Allows developers to create, edit and rename static application, workspace, plug-in, and theme files without the need to re-upload the …

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 …

Data Loading Utility in Oracle APEX COLLECTION Step 1: Create Data Loading Definition Step 2: Select Target Type (COLLECTION Name- DATA_LOADING) Step 3: Sample Data Mapping (Source Type - Upload a File/Copy and Paste) Step 4: File Size and Data definition selection Step 5: Create a page using the Data Definition for …

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

How to Get Device ID in Oracle APEX? Create a page with a page item and paste below Javascript in Function and Global Variable Declaration section as per screenshots. function getCookie(name) { var cookieValue = null; if (document.cookie && document.cookie !== '') { var cookies = …

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 …

1. apex.page.confirm Signature 1. This example shows a confirmation dialog with the text ‘Delete Department’. If the user chooses to proceed with the delete, the current page is submitted with a REQUEST value of ‘DELETE’. apex.page.confirm('Delete Department', 'DELETE'); or …

Invoke Web Services using APEX_WEB_SERVICE in Oracle APEX. Directly pass json in parameter value. DECLARE l_parm_names apex_application_global.vc_arr2; l_parm_values apex_application_global.vc_arr2; l_clob CLOB; P_EMAIL_ID varchar2(100):='ashishk392@gmail.com'; P_CC_MAIL …

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 …

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 …

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

How to upload multiple files in apex collection using Oracle APEX. Create a blank page where there will be a page item and a button as per screenshot. Create a page process for uploading a multiple file to the database or apex collection. declare l_file_names apex_t_varchar2; l_file …

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

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> || '"' ); …