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 
0