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






  1. Oracle PL / SQL
  2. Select Query
  3. Quote

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.








Related examples in the same category

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