Database Administrator

Chinese garbled solution after MySQL is installed in CentOS After the MySQL program has been installed in CentOS recently, Chinese exceptions have been found during data import. The solutions can be sorted out for future reference: The procedure is

Oracle group statement Inquiry Learning notes 1. The group by statement does not have the sorting function in Oracle. order by must be used to sort the statements according to the predefined results. 2. cube extension of group With test(Select 1 id,

Simple installation steps for Oracle 10gR2 Clusterware 1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to

How Does Oracle ASM Add a new disk to a disk? Applicable platform: AIX hp linux win Solaris Applicable versions: all databases 10.1.0.2 to12.1.0.1 Applicable to rac and standalone Take the RAC environment as an example: Assume that Oracle is an

Basic tutorial on getting started with Redis Redis is an open-source, advanced key-value storage perfect solution for building high-performance, scalable Web applications. Redis inherits three main features from its many competitions: The Redis

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

OGG synchronizes two Oracle databases Here is a simple example to illustrate how goldengate synchronizes two Oracle databases.The content is as follows:1. Configure the database information.2. Install golden gate.3. Configure golden gate.4. Test

Oracle uses a cursor to query a string that combines the names of all fields in a specified data table. Application Scenario: refer to the Code for querying all field names of a data table on the Internet, and use a cursor to generate a list of

Use Rails in Ubuntu 14.04 to connect to the MySQL database Rails comes with sqlite3 in all aspects, but the free version lacks a fatal function: Add a password! Although the third party has a compiled binary version of the encrypted version, let's

Database tree query, database tree During this period of time, I worked with others to develop a new function in my internship company. I am mainly focusing on database operations! One of them is data validation, and this data exists in the database

Problem of CDB User Creation and tablespace allocation in Oracle 12c database, 12 ccdb In Oracle12c, the concept of database plug-in is added, that is, PDB, which allows a database container (CDB) to carry multiple plug-ins. Database pulling (PDB ).

Thinkphp association model and thinkphp Model Thinkphp comes with the associated model has_plugin. Use: Create ProductModel. class. php In the Model folder. The Code is as follows: use Think \ Model \ RelationModel; class ProductModel extends

MongoDB master-slave replication configuration, mongodb master-slave Replication The configuration in the mongoDB configuration file shows how to configure it. Here we use the configuration file to configure master/slave for master-slave replication:

[Leetcode SQL] Employees Earning More Than Their Managers, leetcodeearning TheEmployeeTable holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +----+-------+--------+-----------+|

Reconstruction of abstract factory and reconstruction of factory We are familiar with the abstract factory. We have seen it when learning the design model. I also saw it when I started refactoring. However, I have to get a glimpse of it on the paper.

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,

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

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

The random relationship between SQLServer and Oracle corresponds to sqlserveroracle The requirements are as follows: Now we need to complete the singing fields in tb1. The condition is to search for songs sung by the same artist in tb2 and randomly

Oracle trunc () function usage-2, oracletrunc2. TRUNC (for number)The TRUNC function returns the processed value. Its working mechanism is very similar to that of the ROUND function, except that the function does not ROUND or select the part before