QUERY->
Code:
 select *
  from sttb_record_log
 where table_name IN ('STTMS_CUSTOMER', 'STTM_CUSTOMER')
   AND KEY_ID LIKE(SELECT '%' || CUSTOMER_NO || '%'
                      FROM STTM_CUSTOMER
                    )
Error-ora-01427:single-row subquery returns more than one row