Oracle: Character Escape

' - Single Quote

SELECT 'goweekend.ca'||chr(39)||'s website' FROM Dual