Tag Info

New answers tagged

0

Use the parameter NAMES.DEFAULT_DOMAIN to set the domain from which the client most often looks up names resolution requests. When this parameter is set, the default domain name is automatically appended to any unqualified net service name or service name. For example, if the default domain is set to us.acme.com, the connect string CONNECT scott/tiger@sales ...


2

The public link below gives an overview of the four installation type options for the 11gR2 client: http://docs.oracle.com/cd/E11882_01/install.112/e24322/install_overview.htm#LACLI1245 Instant Client: Enables you to install only the shared libraries required by Oracle Call Interface (OCI), Oracle C++ Call Interface (OCCI), Pro*C, or Java database ...


1

Show Variables is not ANSI SQL, it's MySQL specific, so it won't run across database providers. Reading through that code it looks like it's trying to determine if the database provider will support UTF8. If you Google it, the Show Variables is a MySQL command which returns information about the current database. I think you will have to replace this ...


0

show variables LIKE '%_database' in MySQL return like following +------------------------+-------------------+ | Variable_name | Value | +------------------------+-------------------+ | character_set_database | latin1 | | collation_database | latin1_swedish_ci | | skip_show_database | OFF | ...



Top 50 recent answers are included