Using two single-quotes print the string correctly

    
SQL>
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE('C''s');
  3  END;
  4  /
C's

PL/SQL procedure successfully completed.

1.	Alternative Quoting Mechanism in Oracle 10g: two quotes really means one quote
2.	q'{32 O'Hara Avenue}'): Use a 'q' as the leading character after the parentheses
3.	Quoted Identifiers
4.	Quoting syntax is q'[ ... ]' where the [] is the user-defined

Using two single-quotes print the string correctly : Quote « Select Query « Oracle PL / SQL