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''
 

Popular posts from this blog

OracleRemExecService available Windows only

Implementation of a GoldenGate Replicate Hub: GoldenGate Remote Capture and Deliver Goldengate processes

Dynamic listener registration (instance registration) - Connections via the Listener to the Database [TNS-12526 - TNS-12527 - TNS-12528 ]