Description: The purpose of this component is to restrict the copy option from the user level of apex page. SCENARIO : Consider in our apex application we are providing any confidential message or data that should not be copied by the user level;…
Read MoreDescription: This function calls a PL/SQL on-demand process defined on page or application level. It’s a wrapper of the jQuery.ajax function and supports all the setting the jQuery function provides but…
Read MoreDescription: To implement Role-based Authorization in Oracle APEX Application, in version 5. Application Item: USER_ROLE Table: ROLE_ACCESS_CONTROL The purpose of this table is to store the privileges on Regions, Buttons, and Items for…
Read MoreDescription: APEX can create “Percentage Bars” within a report. This can be achieved using HTML Code in your Report SQL Query. Steps: 1- Create your report: Create an Interactive or Classic Report using SQL query : SELECT CASE WHEN COLUMN <= 30 THEN ‘<div class=”a-Report-percentChart” style=”background-color:#000000;width:100%;”><div class=”a-Report-percentChart-fill” style=”width:’ || COLUMN || ‘% ; background-color: 330099;”></div><span class=”u-VisuallyHidden”>’ || COLUMN || ‘</span></div>’ || COLUMN || ‘%’ WHEN COLUMN BETWEEN 30 AND 50…
Read MoreDescription: If double-clicking for Adhoc operations are enabled to IR report in the following steps. Place the below code in HTML Header: <script type=”text/javascript”> $(function(){ $(‘.apexir_WORKSHEET_DATA td’).live(‘dblclick’,function(){ $(‘#apexir_SEARCH’).val($(this).text()); gReport.search(‘SEARCH’); }); }); </script> Summary: The HTML header to enable…
Read MoreDescription: To select multiple values from select list item in Oracle Application Express 4.2. Step 1: Create Select list item. Step 2: Step 3: Output: Summary: The screenshot showed that multiple values from the select…
Read MoreDescription: To set background in Oracle Apex 5 application using CSS (Cascading Style Sheets). Step 1: Create a HTML Region. Step 2: Put a required image into Shared Components. Step 3: In this region, source CSS can be added for setting background. Output: Summary: To set up the background covering image in oracle with the help…
Read MoreDescription: Websites that include many images, such as art or photo gallery sites, can benefit by presenting some (or all) of their images in slide show format. Slideshow of various Images on an Apex Page can be achieved using HTML, JavaScript, CSS, and jQuery. Step 1: Uploading all the images in the Workspace Shared ComponentsàFilesàImagesàCreateàSelect Application nameàChoose image fileàUpload. Step 2: Source code Give the following code in the Page Region source. Make sure that all the images are uploaded in the Workspace. Source Code: <div id=”slideshow”> //opening the Slider division…
Read MoreDescription: To change the “Notification Message Bar” design throughout the Oracle Application Express 4.2 application. Requirement: The customer has asked us to change the default “Notification Message Bar,” because it…
Read MoreRequirement: Navigation menu should be shrinking on page load. Challenges faced: In Oracle Apex 5, universal theme the navigation menu is strengthening on default page load. If we want to shrink the menu we need to click on the navigation menu controller. Resolution: Created a dynamic action with event as page load and condition as JavaScript Expression and value as $(‘#t_Button_navControl’).attr(‘aria-expanded’) === “true”. A true action is provided with JavaScript code as $(‘#t_Button_navControl’).click(); Output:
Read More