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 '

The reason why the Oracle task process is not executed after it is submitted /* Run the following command in SQL * Plus */-- Check steps when the task is not running-- 1. Check whether the instance session is restrictedSelect instance_name, logins

Install MySQL5.5 (single instance) in the source code of CentOS) 1. Media preparation Note: Due to the CMAKE Method Used for MySQL5.5 source code compilation, download the cmake installation package and the MySQL5.5 installation package in

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

Oracle 11g cluster troubleshooting Symptom:The Oracle cluster does not seem to be drifting IP addresses. The number of all session connections is only concentrated on one node. If this node is disconnected, it will not be automatically connected to

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

Install MySQL-server-5.6.22 log in Linux, mysqlserver5.6.22 I recently learned how to install Mysql, read a lot of online materials, and said that many methods of First Login with root fail. I checked the Installation Log carefully. In fact, people

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

ORA-01461 error resolution, ora-01461 ErrorORA-01461 troubleshootingORA-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

Create tens of millions of test tables and mysql database test tables in the mysql databasePreface: I have recently prepared to learn more about mysql, including the features, performance optimization, and database sharding of various engines. To

Use OCCI to access the Oracle database (3), occioracle Now I am writing the code. I don't really want to write it. Let's compile it with an example. In the F: \ PProject \ oci \ 32 \ instantclient-sdk-nt-11.2.0.4.0 \ instantclient_11_2 \ sdk \

Mysql storage engine Introduction # Not easy to write The default INNODB engine is used after ORACLE is acquired. MyISAM Default storage engine before Mysql5.5.5 Supports large files, usually 256 TB Suitable for read-write-less

The impact of the resource role on the quota of quota tablespaces. resourcequota Two days ago, I saw a brother in the Forum saying that the user set the table space's quota, but the data volume that exceeds the quota can still be inserted into the

Write a process to dynamically call the queried field and the string value in the where condition, where string Take the emp table in scott user as an example to compile a stored procedure to query the values of a field in the emp table. However,

NoSQL data model (1) nosqlBackground The previous blog has introduced the overall data model. The following describes the four data models in NoSQL. For example:The concept key-value database is a simple hash table, which is mainly used when all

An error is returned when the access database queries data by date !, Access date select * from sv_JFVoucher where isDelete=0 and [date]>= '2015-1-20 0:00:00' and [date] There is no error in executing this SQL statement in SqlServer08, but an

Linq --- I'll explain the order for you. Your beauty is not only a query statement, but also a write by using This is a group of extensions for the c # and Visual Basic languages. It allows you to write C # Or Visual Basic code to query memory data

Mysql full text search and Mysql full text searchMysql full-text index Note that not all engines Support full-text retrieval. Mysql's most common engines, INnodb and myisam, support full-text retrieval. The former does not support full-text

Oracle Data Type-4, oracle-4 18. NCLOBThe character set defined by the international character set of the database can be used to store character-based data of the Unicode type only. A maximum of 4 GB of data can be stored, which is larger than the

Oracleing table to timesten In oracle, oracletimesten ---- 1. Run the createandloadfromoraquery command and enable six threads. Command> createandloadfromoraquery scott. t1 6 select * from scott. t1;   ---- 2. Use built-in commands to import