Database Blog

Oracle Cloud Infrastructure New feature – Block Volume Elastic Performance

@oracle introduced new feature in Oracle Cloud Infrastructure (#oraclecloudinfrastructure) – Block Volume Elastic Performance. The elastic performance feature of the Oracle Cloud Infrastructure Block Volume service allows you to dynamically…

Read More

Losing Data During Validation In Apex Tabular Form !!! – Check In

Introduction           This post describes the steps required to stop losing the data during validation in tabular form.   Steps to follow   Step:1  On Submit, Before Computation and Validation – Insert into Collections.   Example   BEGIN apex_collection.add_member…

Read More

Download hidden column in APEX classic report

Introduction          This post describes how to download hidden column in a classic report.   Steps to follow   Hidden column cannot be downloaded in classic report if,   Display As : Hidden Include In Export : Yes   This can be achieved using the PLSQL Expression:   Column attributes->   Display As : Display as Text  …

Read More

Remove the close icon from Select2 plugin

Introduction           The purpose of this post is to remove the close icon from the select2 plugin for the value which comes from Item Source.   Challenges faced:  Select2 is an…

Read More

Shrinking of Navigation Menu on page load

Introduction This post defines the steps required to shrink the navigation menu on page load. Challenges faced:  In Oracle Apex 5, universal theme the navigation menu is strengthening on default page…

Read More

Freeze Columns in Tabular Form/ Report (Classical Report)

Introduction               This post is about “How to Freeze/Fix Column Header Row of a Classic Report” which would be very useful when the number of report columns/rows are more per…

Read More

APEX – Report Rows Clickable to detailed page

Introduction  This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection. In Apex, Report is an essential tool which…

Read More

APEX – Report Rows Clickable to detailed page

Introduction  This document describes how to make an Apex Reports clickable to a detailed page with an option of entire row selection. In Apex, Report is an essential tool which…

Read More

Word Wrap in APEX IR

Introduction  One of the common problems with APEX IR is word wrap. Using the below method, we can unwrap the column labels in report. Output: Call To Action:  For Oracle apex development and customization please do contact our company website  https://doyensys.com/   Conclusion…

Read More

Reports with Row Details

Introduction This document describes how to show an Apex Reports with Row Details. In Apex, Report is an essential tool which is in classical, interactive & other formats. Suppose if…

Read More