APEX application Header Logo | Ontoor Shorts #3 In this Short Video Vikas has explained, how can we setup the APEX application header image. Availble Options Text Image Image and Text both

APEX Login Page Templates | Ontoor Shorts #4 In this Short Video Vikas has explained, how can we customize the APEX login page template using APEX declarative templates options.

APEX Dialog Page drawers | Ontoor Shorts #2 In this Short Video Ashish has explained, how can we create drawer effect in APEX dialog pages. Availble Options for Inline regions and Dialog Pages DRAWERS from left DRAWERS from Right

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 …