Posts by Venkatesh Balasubramanian

Multiple selection in select list item – Oracle Apex 4.2

Description: 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 More

How to set background in Oracle Apex 5 application using CSS

Description: 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 More

SLIDESHOW OF IMAGES IN APEX

Description: 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 More

Setting the VO query dynamically in OAF

Description: Generally, while creating the View Objects, we define a query to it. While rendering the OAF page, these view objects get executed (either by framework or by the java…

Read More

Sending E-mail with Excel Attachment Using UTL_SMTP

Description: The utl_smtp package is used to send e-mails from any database to a valid recipient/recipients with or without attachments. The generic code is given to send e-mail with excel…

Read More

Notification Message Bar design change in Oracle APEX 4.2 using CSS

Description: 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 More

Performance Issue – Hierarchical query LEVEL

Description: A parts hierarchy, particularly the case of parts in a kit with the kit/assembly having multiple levels. Another example is parts succession, where older parts are replaced by newer…

Read More

Shrinking of Navigation Menu on page load

Requirement: 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

Search bar for Tabular form with auto complete option for Date values

Description:The search button in tabular form is helpful to identify the exact data in the tabular form, that will act like a filter in interactive report shows the particular values…

Read More

Retain checkbox value after refresh the page

     Step1: Declare global variable to get all the checkboxes   var i; checkboxes = document.querySelectorAll(‘input[type=checkbox]’);  Step2: Use the following function to save the checked checkboxes values into localstorage…

Read More