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
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
Write More, Write Conflict Detection
Excellent scalability, dyna ...
Posted on Mon, 24 Dec 2018 17:06:06 -0800 by Froolah
PostgreSQL, HTAP, OLTP, OLAP, Scenario and Performance Testing
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
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.
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[TOC]1.IP Address PlanningHostnameCurrent IPModified IPPublic IPnode1192.168.56.201188.8.131.52Public IPnode2192.168.56.211184.108.40.206VIPnode1-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
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
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 Index, False Index, HypoPG, hypothetical Index
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
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
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