update column using for each agent — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!