Thanigai Solutions (Oracle APEX Blogs)

🚩Introduction  In Oracle APEX applications, Interactive Reports allow users to download data as Excel or PDF using the Actions menu. While this feature is useful, it can feel a bit inconvenient when users have to go through the same steps every time they want to download a report. This can slow things down, especially when downloads are needed frequently. To make it easier, we can create simple custom buttons that let users download the report with just one click. Even though APEX doesn’t provide this option directly, it can be done using Dynamic Actions without any plugins. This makes the process faster and gives users a smoother and more comfortable experience. 📑Why Simplify Downloads in Interactive Reports In Oracle APEX applications, Interactive Reports allow users to download data in formats like Excel and PDF using the Actions menu. While this works fine, users often find it repetitive to open the menu and select the format every time they need a download. This can slow d...

🚩Introduction  In Oracle APEX applications, Tabs Container components helps to organize multiple regions efficiently. However, APEX does not provide a built-in declarative option to detect which tab is active when users switch between them, making it challenging to trigger conditional logic based on tab selection. This can be solved by creating the custom dyanamic action to capture the tab change. This approach enables dynamic actions like refreshing regions or executing custom logic whenever a tab becomes active, without requiring any plugins. 📑Why It is Essential to Track Tab Change in Tabs Container In APEX applications, pages often organize multiple regions under a Tabs Container to separate content like Details, History, or Reports. While this improves layout, users actions on different tabs often require specific logic to run, such as refreshing a region, loading dynamic content, or updating page items. Without capturing which tab is active, developers cannot reliably trigg...

🚩Introduction  In Oracle Application Express (APEX), Select List items are commonly used to provide predefined values and ensure data consistency. However, APEX does not offer a built-in declarative option to copy the selected value directly using the mouse. Since it is rendered as a dropdown list, the displayed value cannot be highlighted and copied like a standard text field. This limitation can be resolved by creating a custom Dynamic Action using JavaScript. The selected value can be captured programmatically and copied to the clipboard without using plugins. This approach improves usability while maintaining the standard behavior of the Select List component. 📑Why It Is Essential to Enable Copy Functionality for Select List In Oracle Application Express (APEX), Select List values often contain important reference data that users may need to reuse. Since the dropdown content cannot be directly highlighted and copied, it can affect the user experience. Enabling copy functio...

🚩Introduction  Oracle continues to evolve its database platform with the release of Oracle Database 26ai , introducing several new SQL features for modern data needs. These enhancements focus on improving developer productivity and simplifying everyday query writing. It helps developers work more efficiently while handling growing and complex data workloads. In this blog, we are going to explore few SQL features introduced in the Oracle 26ai. I have embedded FreeSQL terminal in this blog, so the learners can do the hands-on straightaway in this blog along with learning. 📑Why SQL Features in Oracle 26ai Matter Modern applications demand faster insights, smarter data processing, and seamless integration with AI capabilities. To support these evolving needs, Oracle Database 26ai introduces several new SQL enhancements that make working with data more efficient and flexible.  Improved Developer Productivity Support for Modern Data and AI Workloads Better Query Performance ...

🚩Introduction  In Oracle APEX applications, Region Display Selector components helps to organize multiple regions efficiently. However, APEX does not provide a built-in declarative option to detect which tab is active when users switch between them, making it challenging to trigger conditional logic based on tab selection. This can be solved by creating the custom dyanamic action to capture the tab change. This approach enables dynamic actions like refreshing regions or executing custom logic whenever a tab becomes active, without requiring any plugins. 📑Why It is Essential to Track Tab Selection in Region Display Selector In APEX applications, pages often organize multiple regions under a Region Display Selector to separate content like Details, History, or Reports. While this improves layout, users actions on different tabs often require specific logic to run, such as refreshing a region, loading dynamic content, or updating page items. Without capturing which tab is active, de...

🚩Introduction  In real-world Oracle APEX applications, Classic Reports often become wide due to data-heavy requirements. Horizontal scrolling is common, but since Classic Reports do not provide a built-in column freezing option, important reference columns such as IDs or names scroll out of view, affecting readability and usability. This limitation can be addressed by implementing custom column freezing using J avaScript and CSS without any P lugins . By fixing key columns, Classic Reports become easier to navigate and offer a spreadsheet-like, enterprise-friendly user experience. 📑 Why Column Freezing is Needed in Classic Reports In data-intensive applications, reports often extend horizontally due to the number of attributes required for business analysis. While horizontal scrolling allows access to all columns, it introduces a usability challenge: users lose sight of key reference information when navigating across the report. To keep important columns (like Name, ID, or Cod...