Scape single quote in dynamic query Oracle
You can use another method to quote strings in Oracle which makes things a lot clearer.
Example:

x := q'[This is John's address]';

y := q'[He said "What's your name ?"]';


You can have as many quote marks as you like so long as they are between the '[]'.
Your code may look something like this

SELECT REPLACE(ISR.STREET_NAME1, q'[']',q'['']')
       || CHR(3) || isr.agency_code || CHR(3) || ''  
  FROM isr, isr_udf
 WHERE isr.isr_no = isr_udf.isr_no
   AND isr.isr_no = 'XXX-20160718-00022'


Link: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/fundamentals.htm#CBJJDDCG