Database Administrator

MySQL group data, mysql GroupFor Grouping comprehension groups, see the next example. First, we print the products table as follows:From the table above, we can see that each vendor has several products. How can we count the number of products in

[Translated from mos] despite specifying a destination, the asmcmd cp command still creates a file under + DATA/ASM, mosasmcmdDespite specifying the destination, the asmcmd cp command still creates a file under + DATA/ASMReference Original:ASMCMD Cp

Differences between left and right connections in the database Differences between left and right connections in Databases Today, someone asked me a question: What is the difference between left and right connections in the database? If there are

[Translated from mos] Use asm to deploy ultra-large databases (10 TB to PB)-for oracle 10 GB and asm10tb Use asm to deploy super-large databases (10 TB to PB) Reference Original:Deployment of very large databases (10 TB to PB range) with Automatic

[Translated from mos] place the dmp file of expdp from the asm disk to the local file system, expdpasmPlace the dmp file of expdp from the asm disk to the local file system.Reference Original:How To Extract Datapump File From ASM Diskgroup To Local

Use resultMap to implement ibatis composite Data Structure Query (1. Multi-attribute query; 2. List query included in the attribute), resultmapibatis Take the order as an example (the order details include the basic information of the Order,

[Translated from mos] the solution for job cannot be automatically executed, mosjobSolution to job failureReference Original:Jobs do not execute automatically (Doc ID 309945.1)Applicable:Oracle Server-Enterprise Edition-Version: 9.2.0.4This problem

[Course sharing] practical development of the Project Management System Based on plusgantt (Spring3 + JDBC + RMI architecture and custom workflow), plusganttspring3 Practical development of plusgantt-based project management system (Spring3 + JDBC +

All oracle queries and tablespaces, and their relationships, oracle Space Select * from dba_users; view all users in the database, provided that you have the dba permission account, such as sys, systemSelect * from all_users; view all users you can

Oracle snapshot management, oraclesnapshotZookeeper ---- Manually create an oracle SnapshotBEGINDBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();END;/ --- Delete a snapshotFor more information about snapshots, see

SQL Server blocks access to the STATEMENT 'openrowset/OpenDatasource 'of the 'ad Hoc Distributed Queries' component. OpenRowset Cause: It appears when the data is copied from the remote server to the local "SQL Server has blocked access to the

Introduction to AspectJ In the AOP framework and aspectj In the aop framework In the past few days, I had a headache when I looked at JAVA basics. I decided to change my taste from time to time and start to investigate some popular technologies. So

MySQL wildcard filtering, mysql wildcard You can use the LIKE operator to filter wildcard characters after the WHERE clause: The products table is as follows: A uses the % wildcard: B uses two % wildcards: C. Use underline _ to

[Translated from mos] When par file is not used, export or import tables with case-insensitive table names, mosparExport or import tables with case-insensitive table names without using the par fileReference Original:How to Export or Import Case

Inaccurate statistics lead to execution plan errors and no results can be run. After optimization, it takes only one minute to count the execution plan. One day, I checked the database for a long session and found that one SQL statement ran very

[Translated from mos] after a failed 'shutdown immediate', the Database job cannot run .,After a failed 'shutdown immediate', the Database job cannot run.Reference Original:Database Jobs Do Not Run After a Failed 'shutdown immediate' (Doc ID 434690.1

Introduction to Greenplum distributed database development to proficient (architecture, deployment, management, development and optimization) [course sharing], greenplum TuningGreenplum introduction to distributed database development is proficient (

Database Connection of ADO. NET database --- ShinePans, ADO. NET technology mainly includes Connection, Command, DataReader, DataAdapter, DateSet, able and other six objects 1). The main function of the Connection object is to connect to the

Database transaction isolation level, transaction isolation level Transaction Features: ACID Atomicity: Atomicity Consistency: Consistency Isolation: Isolation Duration: Persistence   The SQL standard defines four isolation levels for transactions: 1

MySQl subquery, left-right connection, multi-Table connection learning notes, mysql learning notes1. subquery refers to the SELECT clause in another query statement.Example:SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2 );SELECT * FROM t1..