Oracle merge into grammar

In the form of merge into: MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...)   WHEN MATCHED THEN       [UPDATE sql]   WHEN NOT MATCHED THEN       [INSERT sql]   Function: To judge whether table B and table A meet the conditions of ON, if they are satisfied, update table A with table B, if not ...

Posted by kagedwebdesign on Tue, 14 May 2019 19:32:18 +0200

CentOS5u11 Oracle 10g Silent Installation Unified Configuration Scheme for Manual Library Building

Environment-related: OS: CentOS release 5.11 IP: 192.168.77.10 MEM: 16G DISK: 50G 1. Brief description This blog post is actually a silent installation of the CentOS 5 system Oracle 10g in the production environment in use. This blog includes oracle Software silent installation, software upgrade, playing PSU, man ...

Posted by thinguy on Tue, 14 May 2019 13:07:02 +0200

LEYOU MARKET LEARNING NOTES XI-Elasticsearch LEARNING

3.1. Basic queries: Basic grammar GET/Index Library Name/_search { "query":{ "Query type":{ "Query Conditions": "Query Conditional Values" } } } Here query represents a query object, which can have different query attributes. Query type: For example: match_ ...

Posted by IanMartins on Sun, 12 May 2019 14:09:54 +0200

RabbitMQ Introduction: Topic Exchange

In our last blog post, we used direct exchange instead of fanout exchange. This time, let's look at topic exchange. Introduction to Topic Exchange Topic exchange is similar to direct exchange in that it matches routing key and binding key, but topic exchange can set multiple criteria for routing key. direct routers are similar to exact queri ...

Posted by fahim_junoon on Sun, 12 May 2019 09:50:19 +0200

Oracle AWR Report Generation and Performance Analysis

[TOC] 1. Steps to generate AWE reports For SQL tuning, local SQL, we can use direct tuning such as execution plan, for the whole system?Oracle provides several performance analysis reports, such as AWR, ASH, ADDM and so on. This blog focuses on AWR AWR, fully known as Automatic Workload Repository, is a performance collection and a ...

Posted by ranam on Sun, 12 May 2019 08:52:43 +0200

oracle storage functions and stored procedures

stored procedureConcept: Stored Procedure s are large database system In order to accomplish specific functions, a set of SQL statements is stored in the database. After the first compilation, the first call does not need to be compiled again. The user executes it by specifying the name of the stored procedure and giving param ...

Posted by mdemetri2 on Sun, 12 May 2019 06:12:47 +0200

Concise Deployment and Use of MSSQL(SQL Server) on Linux

Label PostgreSQL , ms sql , SQL Server background This paper introduces the simple deployment and use of MS SQL on Linux. https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017 Later, I will briefly introduce how to migrate MS SQL to PostgreSQL. 1 environment CentOS 7.x x64 ECS 2. Environmental ...

Posted by MikeA on Sun, 12 May 2019 02:10:42 +0200

PostgreSQL sharding: citus Series 5 - worker node network optimization

Label PostgreSQL, citus, pgbouncer, network optimization, worker node background Network requirements between citus nodes: 1. The cn node accesses all worker nodes. oltp services are frequently accessed. 2. When data is redistributed, worker nodes visit each other. Access frequency is not high, OLAP business is common, once possible, data ex ...

Posted by nic0las on Sun, 12 May 2019 01:30:39 +0200

Mybatis principle analysis learning record, mybatis dynamic sql learning record

The following personal learning notes are for reference only. You are welcome to make corrections. MyBatis is a persistent layer framework that supports customized SQL, stored procedures, and advanced mapping. It mainly accomplishes two things: Encapsulating JDBC operations Using Reflection to Interchange Java Classes and SQL Statemen ...

Posted by ScratchyAnt on Sat, 11 May 2019 16:37:13 +0200

Proxy SQL (11) of MySQL Middleware: Chain Rules (flagIN and flagOUT)

Return Proxy SQL Series: http://www.cnblogs.com/f-ck-need-u/p/7586194.html   1. Understanding Chain Rules In the mysql_query_rules table, there are two special fields, "flagIN" and "flagOUT", which are used to define the entry and exit of the rules respectively, so as to realize the chains of rules. The implementation of ch ...

Posted by pob123 on Sat, 11 May 2019 15:33:54 +0200