Looping Through Interactive Grid Oracle APEX - Part 22

In this video, you learn how to loop through each record in an interactive grid to perform some kind of validation. For example, here you will prevent addition of duplicate products in a single order. Of course, you can add a composite unique key constraint on the corresponding table to prevent duplication. But, there are some scenarios where this solution doesn’t fit. For example, if you provide some free samples of a product in an invoice, you need to create two line item entries in your order screen for the same product – one with a price tag and another free.

Topics Covered in this video:
=============================
- Validation and Dynamic Action which Detects Duplicate Product records through JavaScript Code
- Dynamic Action to Fetch Product Name
- JavaScript function to alert about duplicate record
- Data Manipulation Language Operations to check the segment

Note that this is a multi-part series and some of the topics listed below will be covered in subsequent videos and some are already covered in previous videos.

Topics Covered:
=======================
- Implement master/detail forms
- Sorting Interactive Report
- how to save a modified interactive report
- Add Control Breaks to an interactive report to group related data
- Apply highlight rules to mark specific records
- Using Aggregate functions
- Using Chart and Group By views in an interactive report
- Creating Primary, Public, and Alternative versions of an interactive report
- Utilizing Copy Page utility
- APEX Collection
- Adding custom processes and dynamic actions
- Using HTML in PL/SQL code
- Using CSS on APEX pages

Download Source Code From Here:-
https://drive.google.com/drive/folders/1igXPnijHLxLrSgbnuGzODJxnTEestCjI?usp=sharing

The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
https://www.amazon.com/Create-Rapid-Low-Code-Applications-Oracle/dp/B09P1HFBX1?&_encoding=UTF8&tag=booksrevie027-20&linkCode=ur2&linkId=b051e79b7a59cb6fbac5ffdcc90cf4b7&camp=1789&creative=9325

Видео Looping Through Interactive Grid Oracle APEX - Part 22 канала Tech Mining