The result set from the following query will have an ADDRESS column that is the concatenation of the ADDRESS1 and ADDRESS2 columns from the CUSTOMER table, with every occurrence of 'st.' replaced with ' street'.
SELECT OREPLACE(ADDRESS1||ADDRESS2, ' st.', ' street') AS ADDRESS from CUSTOMER;