Database Administrator

Oracle subquery, oracle subquery Subquery: contains another query within a query. Common subquery -- Query the information of all employees whose salaries are higher than 7654. select * from emp e where e. sal> (select sal from emp where empno = 7

The sixth day of oracle learning and the sixth day of oracle LearningZookeeper 1. Review in the previous section2. PL/SQL Introduction3. Basic PL/SQL Understand oracle pl/SQL conceptsMaster PL/SQL programming technology (including programming

Queries the minimum wage information of each department and the department wage information. Example: Query the minimum wage information of each department Join subquery Method 1. query the minimum wage of each department select deptno, min(sal)

Oracle user management instance, oracle user management User Roles in oracle are divided into predefined roles and custom roles.A role is a combination of common permissions to form a role.Authorization/Role Assignment CommandGrant permission/role

Couch MapReduce query, CouchMapReduce 1. MapReduce introduces the traditional relational databases. As long as your data is structured, you can perform any type of query. Apache Couch, in contrast, uses MapReduce (a predefined map and reduce

[Err] 1136, err1136 1 error description [Err] 1136-Column count doesn't match value count at row 1 Procedure execution failed1136-Column count doesn't match value count at row 1 2 error cause During the storage process, when a temporary

Mongodb Study Notes 04, mongodb Study NotesCursor Var cursor = db. collectionName. find () create a cursor Whether cursor. hasNext () has the next element Cursor. next () retrieves the next element, for example, while (cursor. hasNext ()

MySQL: root Login for multiple instances on one host, mysqlroot If multiple MySQL instances are created on one machine, for example, the port number is 3306,330 7, 3308 Select a different mysql. sock file when logging on. Mysql-uroot-p123456

SQL high-performance Stored Procedure paging and SQL stored procedure Paging USE [Lyjjr] GO/****** Object: StoredProcedure [dbo]. [P_ViewPage] Script Date: 05/29/2015 17:18:56 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ongo alter proc [dbo]. [P_

Oracle multi-Table query, oracle Basic multi-Table query syntax The implementation of cartesian products in SQL is not only Cross Join ). All join methods are converted into temporary Cartesian Product tables. Cartesian product is a concept in

Basic MySql knowledge, storage engine and common data types, basic mysql knowledge Original works of Lin bingwen Evankaka. Reprinted please indicate the source http://blog.csdn.net/evankaka This article will mainly explain some basic knowledge about

SQL Study Notes (21) ----------- triggers and SQL triggers Trigger: monitors a situation and triggers an operation. Four elements of trigger creation Syntax: 1. monitoring location (table) 2. monitoring event (insert/update/delete) 3. trigger time

Database Control is abandoned after Oracle Database 11.2, oracle11.2 Database Control is abandoned after Oracle DB 11.2Reference:Database Control To Be Desupported in DB Releases after 11.2 (Doc ID 1484775.1) Applicable:Oracle Server-Enterprise

Oracle & mysql Log information, oracle Official WebsitePreface The log information here refers to the log information used to perform command operations on the command line.Oracle1. Import and Export: imp omjx/ppet1205 @ xforcl full = y file = full

Hibernate Learning (query), hibernate Learning ( Data Query is a highlight of hibernate. hibernate provides a variety of query methods for programmers, including the following:1. hibernate language query, that is, the hql query we need to talk

SORTEDSET for Redis data type, redissortedset Web programmer blog: http://blog.csdn.net/thinkercode Sorted set type-Features Sorted set is an upgraded version of set. It adds an ordered Attribute Based on set. This attribute can be

Redis data type: SET type; redis data type: set Web programmer blog: http://blog.csdn.net/thinkercode Set Type-Features Set is a set. It is similar to the set concept in our mathematics. It adds and deletes elements to a set, and performs

Information_schema in mysql (similar to the system table in SQL) and mysqlschema Information_schema database table description: SCHEMATA table: Provides information about all databases in the current mysql instance. Is the result of show

Summary of oracle ebs architecture and management basics (12.1.3), ebs12.1.3 Document directory Blog of Sunan Sheng 1. Overall architecture 2 1.1 directory structure 2 1.2 layer-3 logical architecture 3 2. Basic management 5 2.1 start

Oracle instance Performance Analysis and Optimization-AWR learning summary, oracleawrSummary Sunan Health Blog's article ORACLE performance optimization includes instance performance optimization and SQL statement performance optimization. They