Database Administrator

Summary of the use of the like keyword in Oracle Use like in Oracle for fuzzy search: Assume that the table name is hs_test, and the field name is client_id. 1. query which has 03 in client_id: Select client_id from hs_test where client_id like '

SQL collection (notes) SQL is about the set Oracle is a relational data, where data tables are a set of regular data. Therefore, when using SQL statements, it will save a lot of efficiency if you can follow the set idea, it also makes the

Implement distributed locks using Redis scripts Redis is widely used in distributed environments. It is a problem immediately to solve the locks in distributed environments. For example, in our current mobile game project, servers are divided by

RHEL7.0 VNC remote Oracle 11gR2 installation error Solution Oracle 11gR2 is installed on a 64-bit vmmachine RHEL7.0 64-bit system. There are two problems encountered during the installation process, and the installation using 6.2 and 6.6 has not

Oracle will you really use the ltrim/rtrim function? The common usage is to remove spaces. How many people do not know that they can actually remove spaces? It has the ltrim () and ltrim (x, y) methods. ------- Go to the two sides of the space, go

TNS-01251: Cannot set trace/log directory under ADR 11204 RAC environment error TNS-01251: Cannot set trace/log directory under ADR LSNRCTL> set current_listener listenerCurrent Listener is listenerLSNRCTL> set current_listener listenerCurrent

MySQL1130 remote connection does not have permission Solution There are two reasons for the lack of permissions for remote connection to MySQL: one is the limitation of MySQL and the other is the limitation of firewall. 1. Solve firewall

ORA-01461 troubleshooting ORA-01461 error Solution: ORA-01461: can bind a LONG value only for insert into a LONG columnThe connection pool of weblogic is used, and there is no problem.Switch to tomcat or direct jdbc call, and an error is

Common command set, Common commands in linux Database Server (many databases)-database (many tables)-table // Display all databasesMysql> show databases;// Create a new databaseMysql> create database name;// Enter the databaseMysql> use Database

Use OCCI to access the Oracle database (4), occioracle This article focuses on problem summary and will be updated in the future. 1. When executing Environment * env = Environment: createEnvironment ();, an exception is thrown. The code isORA-32104,

Mysql statement optimization Summary (1), mysql statement optimization Summary SQL statement optimization and Indexing 1. Innerjoin and left join, right join, subquery A. inner join is also called an equijoin, while left/rightjoin is an outer

H2 database functions and data typesH2 database functions and data types Author: chszs, reprinted with note. Blog homepage: http://blog.csdn.net/chszs I. Common H2 Database Data Types INT type: corresponding to java. lang. Integer REAL Type:

Detailed usage of OpenSessionInViewFilter, opensessioninviewPublic void doFilter (ServletRequest request, ServletResponse response, FilterChain chain) {try {Session session =... sessionFactory. getCurrentSeesion (); // get the session object tx =

ORACLE-009: Stored Procedure locking, oracle009 Stored Procedure Recently, we have encountered a situation where only one process can be executed in a stored procedure, and the last process is executed and then executed. This is similar to thread

In asp.net (C #), multiple dropdownlists and TextBox multi-condition queries are implemented, Multi-condition query is implemented through statement concatenation. Main Code: protected void btn_search_

Only one repeat data record is deleted in Oracle and one repeat row in oracle.SQL statement for querying and deleting duplicate records 1. Search for redundant duplicate records in the Table. duplicate records are based on a single field (Id) select

Common Redis commands and redis commands 1. SELECT command Redis has 0 ~ For 15 databases, SELECT 6 is used to operate under database 6. 2. SET: Value Assignment Command SET server: name "fido" to SET Key to server: name and Value to "fido" 3.

TNS-12535: TNS: operation timed out and TNS-00505: Operation timed out processing, tns-12535tns-00505Preface: View alert logs and find many error messages:[Oracle @ localhost trace] $ more alert_powerdes.log**************************************** **

Android database addition, deletion, modification, query, ListView, and page Jump implementation, androidlistview Let's just look at the code: first create a person object. Import java. io. serializable; public class Person implements Serializable

ReportingServies -- SQL Server Report Development Comprehensive instance, SQL Server trigger instance Document directory ReportingServies report development instance tutorial ReportingServies -- SQL Server Report Development Comprehensive