update column using for each agent
Use Case:
I want to use a FOR EACH function for my case.
I want to update the order_base_gid
in the order_release_line
(orli
) table based on the value from the order_release
(orr
) table.
The relationship is:orli.order_release_gid = orr.order_release_gid
Sample Data:
Table: order_release
order_release_gid | order_release_xid | order_base_gid |
---|---|---|
PL/EXIM.OREXIM20250416-0001 | OREXIM20250416-0001 | PL/EXIM.JKT-1-24-0001 |
Table: order_release_line
order_release_line_gid | order_release_gid | order_base_gid |
---|---|---|
1111 | PL/EXIM.OREXIM20250416-0001 | (empty) |
1112 | PL/EXIM.OREXIM20250416-0001 | (empty) |
Goal:
Update the