Database Administrator

Solve Chinese garbled characters in Oracle databases in LinuxChinese garbled characters are displayed in Oracle databases in Linux 1. Cause of garbled Oracle database:The operating system is consistent with the server, but the client and server

Oracle 11g RAC database creation times ORA-00119 and ORA-00132 errors When the Grid is installed on Oracle 11g RAC and the library software is also created, the following error is reported when the database is created: ORA-00119: Invalid

ORA-02270: the unique keyword or primary key of this column list does not match some ideas ORA-02270: the unique keyword or primary key of this column list does not match some ideas View the structure of two tables SQL> describe student; Name Type

MySQL Group Commit Group submission details Group commit is used to optimize disk flushing during log writing. It supports only InnoDB redo log group submission at the beginning, and supports redo log and binlog group submission at the same time in

Efficient data migration using the table space technology that can be transferred This article demonstrates the Oracle tablespace migration process and many precautions. Tutorial objective: to migrate the tablespace TBS_SEC_D on the oracle 10g

The simplest MySQL tutorial in history () "transactions (below )」, Tip: This series of blog posts have been synchronized to GitHub. The address is "mysql-tutorial". Thank you for your interest.Star,Fork, Error correction. Tip: In transaction

Analysis of the use of exists and in MySQL, analysis of mysqlexistsin Exists External table query by loop one by one. Each query will view the exists conditional statement. When the conditional statement in exists can return the row of the record

Dry Goods | Spark SQL metadata dual-master high availability solution secrets, spark metadata Click "ZTE developer community" at the top to follow us Read an original article by a front-line developer every day Source | ZTE Big Data " Open-source

Android learning notes-database development-2-using SQLite and androidsqlite Previous Article: introduces the SQLite concept and two basic classes in android: SQLiteDataBase and SQLiteOpenHelper This article mainly uses the code to implement the

See you on Thursday | from 50 to 0.59 seconds, making SQL optimization impossible by Songhua, IT Jianghu baixiaosheng SpeakerGuest: Zheng Songhua Zhishutang "SQL optimization and Development" course instructor No.: qidan3500 Daniel

Transcript: Replication Technology in MySQL 8.0, mysql8.0 Song Libing, R & D Engineer of Oracle MySQL, gave a speech on "replication technology in MySQL-8.0" at the recent seventh data technology carnival, this paper introduces the development

Dbcp2 data source configuration details, dbcp2 details DBCP2 detailed configuration table common link configuration Parameters Description Username User name passed to the JDBC driver for connection Establishment

Install Redis and visualization tools in Windows, and visualize redis Redis is officially supported by Linux, and there is nothing to say about installation and use. General use can be done within five minutes according to official instructions.

Talking about the function and principle of database index, talking about database index A database index is an identifier attached to a table field to increase the query speed. Many people mechanically understand the index concept and believe that

Detailed description of Database Server construction and deployment check list, detailed description of Database Preface We may often install and deploy database servers, but we may suddenly forget a certain setting, which poses a risk for future O &

Comparison between MySQL and Oracle 2 Basic Syntax: mysqloracle Basic syntax No. Category ORACLE MYSQL Note 1 Variables are declared differently. Li_index NUMBER: = 0 DECLARE li_index integer

Description: sqlSessionFactory injection method of MapperScannerConfigurer, sessionfactory Injection SqlSessionFactory injection for MapperScannerConfigurer First, there is a configuration in Mybatis that is very convenient, saving us time to write

Mybatis project configuration file instance details, mybatis configuration file Mybatis project configuration First, this is a simple mybatis project configuration file: Environment Mybatis supports multiple

Detailed description of mybatis ing XML files and examples, and detailed description of mybatis ing xml Mybatis ing XML files A simple ing file: Of course, this file does not contain any elements. The Mapper XML files have only a few first class

Examples of getting started with SQL Injection Preface Before learning this article, you can refer to the basic knowledge necessary for SQL injection to learn the prerequisites for SQL injection. Understanding SQL Injection From the very beginning,