Quote « Select Query « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Select Query
  3. Quote
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
5.Using two single-quotes print the string correctly