Oracle - Type, grammar, attributes and usage of cursors, differences between NO_DATA_FOUND and% NOTFOUND (reprint)

Classification of cursors Oracle database provides two kinds of cursor types, static cursor and dynamic cursor, while static cursor is divided into hermit cursor and explicit cursor, dynamic cursor is divided into weak type and strong type. II. Static cursor 1. Explicit cursor1. Declare cursor grammar: Cursor cursor cursor ...

Posted on Mon, 24 Dec 2018 19:42:06 -0800 by alarik149

Deployment of MySQL Group Replication multiple master modes under Centos 6.8 (5.7 new features)

MySQL Group Replication (MGR) is a new high availability and high scalability solution launched by MySQL in December 2016. MySQL group replication provides high availability, high scalability and high reliability MySQL cluster services. 1. Introduction to MGR 1.1 features: Write More, Write Conflict Detection Excellent scalability, dyna ...

Posted on Mon, 24 Dec 2018 17:06:06 -0800 by Froolah

HTAP database PostgreSQL Scenario and Performance Testing 15 - (OLTP) Internet of Things - Query data in a time interval

Label PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing background PostgreSQL is a database with a long history, which can be traced back to 1973. It was first awarded by the 2014 Computer Turing Prize winner and the originator of relational database. Michael_Stonebraker PostgreSQL has similar functions, performance, architectur ...

Posted on Mon, 24 Dec 2018 09:48:06 -0800 by justdiy

How RDS for MySQL uses Percona Toolkit

Percona Toolkit contains a variety of tools for MySQL database management. Following is a description of the common use of pt-online-schema-change and pt-archiver with RDS MySQL. Note: Both pt-online-schema-change and pt-archiver tools must specify the no-version-check option to be used with RDS MySQL instances. This sample is tested using ve ...

Posted on Sun, 23 Dec 2018 23:33:06 -0800 by ThaboTheWuff

oracle 10g rac modifies public ip, vip and private ip

oracle 10g rac modifies public ip, vip and private ip[TOC]1.IP Address PlanningHostnameCurrent IPModified IPPublic IPnode1192.168.56.20192.168.100.20Public IPnode2192.168.56.21192.168.100.21VIPnode1-vip192.168.56.98192.168.100.98VIPnode2-vip192.168.56.99192.168.100.99Private IPnode1-priv10.1.1.110.10.10.1Private IPnode1-priv10.1.1.210.10.10.22. ...

Posted on Sun, 23 Dec 2018 10:54:06 -0800 by perry789

Performance test of INNER JOIN and sub-query IN in SQL Server

This month, I met several people who asked me about the performance of INNER JOIN and IN in SQL SERVER. This problem. In fact, this summary is the superiority and inferiority of INNER JOIN and sub-query in SQL Server (IN is one of the ways to implement sub-query, this article only compares the performance of INNER JOIN and sub-query IN. If we c ...

Posted on Sat, 22 Dec 2018 18:27:06 -0800 by bigfunkychief

PowerShell connects to SQL Server database to perform DML, DDL, DCL operations

Standard Origin: http://www.cnblogs.com/wy123/p/6426261.html    Just as ADO.NET connects to data to perform add/delete check and change operations, PowerShell can also connect to the SQL Server database and perform add/delete check and change functions. In addition, PowerShell can also perform DDL and DCL operations. In addition, it supports ...

Posted on Fri, 21 Dec 2018 19:09:06 -0800 by eludlow

PostgreSQL virtual | hypothetical index - HypoPG

Label PostgreSQL, Virtual Index, False Index, HypoPG, hypothetical Index background DBA is actually a scarce resource. Many enterprises do not even have DBA, or SA, developers work part-time DBA. For general users, they have limited knowledge of database, especially in SQL optimization. The most commonly used and fast-acting means of SQL opt ...

Posted on Fri, 21 Dec 2018 18:33:05 -0800 by mator

[Web Form of asp.net] Write database operation class--abstract factory

Understanding Abstract factories In ADO.NET, the operation steps of SqlServer, Mysql and so on are similar, but the difference is: SqlServer uses SqlConnection, SqlCommand, SqlData Adapter for its operation. MySql uses MySql Connection, MySqlCommand, MySqlDataAdapter, and these connection classes of operation classes ...

Posted on Thu, 20 Dec 2018 17:12:05 -0800 by j05hr

Query Task of ArcGIS API for Js

Query Task of ArcGIS API for Js Implementing Functional Description Understand the relationship between Query and Query Task Implementing Relevant Queries for Publishing Layer Attribute Information Relevant Visual Display Based on 3D Symbol and Information Template Pop-up Relevant mechanisms of dojo/_base/array Code for implementation ...

Posted on Thu, 20 Dec 2018 12:36:05 -0800 by robertaccettura