APEX Page Designer Attributes| Ontoor Shorts #1 In this Short Video Ashish has explained the updated location of Page components attributes location.

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 …

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

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 …

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 …

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 …

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

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

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

APEX Page Access Protection Oracle APEX provides various types of Page access protection (Page level declarative). We can utilize them as per the required scenario. Let’s see all of um one by one … Available options include: Unrestricted :- The page may be requested using a URL, with or without session …

APEX_SESSION ATTACH Procedure In my previous blog , I have shared the way to query APEX_COLLECTIONS data from database backend itself. That approach needs to follow three steps. Setting up Workspace Setup Application ID Setup Session id Today let’s explore the APEX_SESSION API. And specifically ATTACH …

Installing APEX 21.1 Oracle APEX Dev team announced the APEX 21.1 on May 12 2021. Let’s get it installed and running. Step 1 Download Step 2 Extract Step 3 Create PDB for APEX 21 Step 4 Installation Step 5 Loading Images Download Download APEX 21.1 from oracle as per language preference. Extract Zip file …

APEX_LANG APEX_LANG.MESSAGE API is great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very usefull to translate the messages or string returned from PL/SQL stored procedures, functions, triggers, packaged procedures, and functions. …

Lazy Loading Specify whether to load the region independently of the data for the region. When lazy loading is specified, the page is rendered immediately, showing an empty region, until the data is loaded. Generally, the page is not displayed until all of the page is loaded and ready to be rendered. Therefore, if it …

Add Custom Validation to the Interactive Grid Interactive Grid Static ID - emp Use SAL as column Name for below example. JavaScript Code var gridID = "emp"; var ig$ = apex.region(gridID).widget(); var grid = ig$.interactiveGrid("getViews","grid"); var model = …