-- https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/DEREF.html
INSERT INTO address_table VALUES
  ('1 First', 'G45 EU8', 'Paris', 'CA', 'US');
INSERT INTO customer_addresses
  SELECT 999, REF(a) FROM address_table a;
SELECT address
  FROM customer_addresses
  ORDER BY address;
SELECT DEREF(address)
  FROM customer_addresses;