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

-
OracleRemExecService is a service which is only used temporarily by the OUI It gets removed when OUI is finished with it, therefore, it will have a value of 'DISABLED' until a reboot - then it will simply be gone, ignore and leave this service untouched. The Oracle Windows service "OracleRemExecService" to execute various commands from Oracle applications like DBCA and GUI. The service itself relies on a named pipe to receive the commands.
Read more

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

-
If you are using dynamic listener registration (instance registration). The instance does not register with the listener until you mount the controlfile.  Without sysdba, Net service name using SID or Net service name using SERVICE_NAME with UR=A . RMAN requires a static listener entry and the tnsnames.ora should not contain FAIL_OVER=ON or LOAD_BALANCING. Just a plain vanilla dedicated server connection. RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Read more

Connecting CMAN - Traffic Director Mode to an Oracle Database

-
Image
Oracle Connection Manager (CMAN) serves as a proxy for database connections within Oracle deployments. It facilitates the transmission of client requests to the Oracle Database and seamlessly transmits the database responses back to the client, whether it be an application, middle-tier, or other components. CMAN operates as a versatile networking solution, providing features such as TLS security, protocol switching/routing, and session multiplexing to enhance the accessibility of both local and remote Oracle databases. Traffic Director Mode (TDM) is an intelligent layer introduced in Oracle Client 18c and beyond, designed to enhance CMAN. TDM introduces additional dimensions to the system, including transparent High Availability (HA) with outage support , advanced security features for cloud environments (protection against DoS and fuzzing attacks, tenant isolation, etc.), and capabilities for optimizing performance. In summary, CMAN-TDM allows any client application to establish a ...
Read more