Oracle APEX: Modifying and Customizing Pages and Reports – Adding Columns to Tables

[admin]

Description:
In this video, we will walk you through the process of modifying and customizing Oracle APEX Pages and Reports, with a focus on adding new columns to a table and displaying them in various types of reports. You’ll learn how to:

Add a Column to an Existing Table

Step-by-step instructions on how to modify your database schema by adding a new column to a table using Oracle APEX. This includes the necessary SQL commands and tips for maintaining data integrity.
Update Classic Reports

Learn how to add the newly created column to your Classic Report. We'll show you how to refresh your report’s layout and ensure the new column is displayed properly within the report’s data.
Modify Interactive Reports

Explore how to include the new column in an Interactive Report. This part demonstrates how to update the report's query, adjust its filters, and offer interactive features (such as sorting and searching) for the newly added column.
Faceted Search Customization

Understand how to add the new column to a Faceted Search Data Entry page. You’ll see how to enable search filters and display data based on the newly added field, providing a more dynamic user experience.
By the end of the video, you'll have a clear understanding of how to extend and personalize your Oracle APEX applications with custom reports, making it easier to manage and present data tailored to your needs.

Topics Covered:

Adding a column to a table in Oracle APEX
Customizing Classic Reports with the new column
Updating Interactive Reports and their filters
Modifying Faceted Search for enhanced data entry and filtering

VIDEO
https://youtu.be/7hIOxvtBaoo