Mega Code Archive

 

Categories / Oracle PLSQL / Select Query

 

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.