Quoting syntax is q'[ ... ]' where the [] is the user-defined : Quote « Select Query « Oracle PL / SQL

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

Quoting syntax is q'[ ... ]' where the [] is the user-defined

    
SQL>
SQL>
SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE('Colorado''s National Parks are BEAUTIFUL');
  3  END;
  4  /
Colorado's National Parks are BEAUTIFUL

PL/SQL procedure successfully completed.

SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE(q'!Colorado's National Parks are BEAUTIFUL!');
  3  END;
  4  /
Colorado's National Parks are BEAUTIFUL

PL/SQL procedure successfully completed.

SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE(q'[Colorado's National Parks are BEAUTIFUL]');
  3  END;
  4  /
Colorado's National Parks are BEAUTIFUL

PL/SQL procedure successfully completed.

SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE(q'<Colorado's National Parks are BEAUTIFUL>');
  3  END;
  4  /
Colorado's National Parks are BEAUTIFUL

PL/SQL procedure successfully completed.

SQL> BEGIN
  2     DBMS_OUTPUT.PUT_LINE(q'%Colorado's National Parks are BEAUTIFUL%');
  3  END;
  4  /
Colorado's National Parks are BEAUTIFUL

PL/SQL procedure successfully completed.

   
    
    
    
  

Related examples in the same category