Dynamic SQL UPDATE

NEED TO UPDATE table columns with dynamic values (not known in advance).

A. ORACLE 

i.Single-Column update

   [Working example.. just replace table names]

   UPDATE station s

        SET vhf_network_id = 

                (

                SELECT vhf_network_id

                FROM vhf_network v  

                WHERE s.client_license_id = v.client_license_id

                )

        WHERE s.station_charge_id = 5;
 

ii. Multiple update

    The key here is to maintain the order and count of the columns in the source columnlist and destination columnlist

  UPDATE
    SET () = 

          (
          SELECT
          FROM
          WHERE

          )

    WHERE ;

B. POSTGRES EQUIVALENT

   Working example (difference with the above is the absence of INNER SELECT)

  UPDATE station s
      SET vhf_network_id = v.vhf_network_id
    FROM vhf_network v
    WHERE s.client_license_id = vhf_network.client_license_id;