In general, anytime you have strange characters you want to insert, you can use the CHR function. For the single quote it is CHR(39).

If you want to see a listing of what all of the characters are, here is a little trick :

select rownum, chr(rownum) from dba_objects
where rownum < 300;