Oracle Q-quote - example
A quick reminder for me how to use Oracle SQL Q-quote.
SQL> select q'['welkom',' yesterday ]'||object_name||q'[', when'']' stmt from dba_objects where rownum <2; STMT ---------------------------------------- 'welkom',' yesterday I_COBJ#', when''
SQL> select q'#'',' yesterday #'||object_name||q'[', when'']' stmt from dba_objects where rownum <2; STMT ---------------------------------------- '',' yesterday I_COBJ#', when''