New Features of Oracle 11g: User rename
Oracle Data is constantly changing during project development. Therefore, we need to regularly import the development database to the test database. The common practice is "trilogy :"
1. Export data from exp
Oracle 11g update PSU detailed steps
Oracle releases the latest patches every quarter. For production O & M personnel, regular system upgrade and patching are indispensable in daily work.
Compared with the previous versions, Oracle patching has
Oracle GoldenGate causes imp to have a ORA-32588 Error
The customer said that the following error was reported when importing data to the source database after GG was implemented:
From this error, we can see that adding logs of all column type to
MySQL online backup and recovery tools --> XtraBackup
1 Overview of Xtrabackup principles
Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to
SQL Server automatic backup, automatic compression, automatic deletion of old backup, SQL Server backup Compression
Preparation tools:SqlServer2008WinRar
1. Set a scheduled backup for SqlServerThis operation is relatively simple. Simply add a
Installation and uninstallation of Oracle11g and use of common tools, oracle11g installation and uninstallation
Installation and uninstallation of Oracle11g and use of common tools
Purpose:
(1) master the installation and uninstallation processes of
Data cleansing Note: correct English date conversion reports "invalid month", note English
Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have
The Oracle time format and integer format are converted to each other, and the oracle time format is integer.
If the time field of the Oracle database is set to the "NUMBER" type, the query Time column is displayed as a numerical value, such as the
Tips for improving PostgreSQL Performance
In a (poor) PostgreSQL query, only a small change is required (ANY (ARRAY [...]). to ANY (VALUES (...))) the query time can be reduced from 20 s to 0.2 s. From the simplest use of explain analyze, to the use
SQL is required. Note: Chapter 1 Join a table. SQL is required.12.1 connections
One of the most powerful functions of SQL is to join a table during execution of data queries.12.1.1 relational table
The appearance of the same data multiple times is
Use scripts to implement dynamic data sources for reports and dynamic data sources for reports
Some reports in the report system often need to connect different data sources according to the conditions to complete report presentation. This kind of
Description of PK, NN, UQ, BIN, UN, ZF, and AI fields in mysql workbench, and workbenchuq
When using mysql workbench to create a table, the fields include PK, NN, UQ, BIN, UN, ZF, and AI basic field type identifiers.
They respectively mean:
PK:
Excel uses ADO to call SQL Server Stored Procedures and ado stored procedures
Test environment: SQL Server 2014, Excel 2013
Excel example File Download: http://download.csdn.net/detail/zhanghongju/8533555
In the early stage, I made a small software
How does one count the number of online users per hour ?, Count the number of online users
The system has a table that records user logon and logout logs. Now, the number of online users is measured in an hour. This is a mathematical problem.
Case 1:
Relational Database V. S. Non-relational database, relational database v. sThe most important feature of a relational database is transaction consistency: The read and write operations of a traditional relational database are transactions and
Basic Database SQL syntax and basic SQL syntax
Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688
Basic Database SQL syntax
1. Create a SQL database,
Open SQL Server Management Studio, click "new query", and enter the following
Shang Silicon Valley-mybatis Quick Start,-mybatis Quick Start1. Introduction to Mybatis (ibatis)
MyBatis is an excellent persistent layer framework that supports common SQL queries, stored procedures, and advanced mappings. MyBatis eliminates the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.