Thanigai Solutions (Oracle APEX Blogs)

🚩Introduction  In Oracle APEX 26.1, a new enhancement is introduced in the Faceted Search which allows users to exclude specific facet values in the filtering the reports. Instead of selecting the required values in the facet, user can now exclude the unwanted values from the results. This makes filtering easier and gives users more control when working with large amounts of data. This feature makes reports searching easier and more flexible. It helps users quickly find the information they need. It also allows developers to build more interactive and user-friendly Oracle APEX applications. 📑  Why This Approach Is Needed In Oracle APEX applications, users often work with large reports and need an easier way to filter data. In earlier versions, users can only select the values they wanted to include, which sometimes made searching less flexible and more time consuming. With Oracle APEX 26.1, the new Faceted Search enhancement allows users to directly exclude specific value...

🚩Introduction  In modern Oracle APEX applications, keeping the interface clean and easy to use is very important. One useful feature is the three-dot button (⋮) , which opens a popup menu and allows users to access multiple options in one place. Instead of displaying many action buttons on the screen, users can simply click the three-dot button to view additional options in a popup menu . This helps keep the page neat, improves usability, and provides quick access to important actions. 📑  Why This Approach Is Needed In Oracle APEX applications, users often need quick access to actions or options without going through multiple menus or screens. Displaying too many options directly on the page can make the interface look crowded and difficult to use. Using a three-dot popup menu becomes useful when: Users need quick access to multiple actions from a single button The page should stay clean and well organized Users should be able to find options without too much navigation Ap...

🚩Introduction  In Oracle APEX applications, users often need to download multiple files at once, such as reports, documents, or attachments. Instead of downloading each file individually, we can improve the user experience by combining all selected files into a single ZIP file. Using an Application Process in Shared Components along with PL/SQL, we can dynamically collect multiple files and generate a ZIP file for download. This approach removes the need for external tools or plugins and makes file handling easier, faster, and more efficient within the APEX environment. 📑  Why This Approach Is Needed In Oracle APEX applications, users often need to download multiple files at once, such as reports, images, or documents. Downloading files one by one can be time-consuming and inconvenient, especially when dealing with large numbers of files. Creating a ZIP file using an Application Process in Shared Components is useful when: You want to avoid multiple individual downloads User...

🚩Introduction  In Oracle APEX , Interactive and Classic Reports work with SQL queries, but procedures that return REF CURSORS cannot be used directly. This creates a gap when your data logic is written in PL/SQL but your report expects a query. Pipelined table functions solve this by converting REF CURSOR output into a format that behaves like a table. This lets you reuse existing procedures while still feeding data into APEX reports using simple SQL, keeping your application clean and easy to maintain. 📑  Why This Approach Is Needed In Oracle APEX , reports need SQL queries, but many times data may comes from procedures that return REF CURSORS. These cannot be used directly in reports, which makes it harder to show the data without changing existing code. By using a pipelined table function, you can convert that data into a simple SQL query format. This helps you reuse existing logic, avoid repeating code, and automatically show updated data in reports. It keeps the appl...