NAV: SLTechnology News&Howtos > Database >

• 

  What is the difference between rollup function and cube function?

  Some partners will find that the data statistics report will often make a summary of the column at the end, so which functions are used to achieve the summary in oracle? Today, let's talk about the distinction between the rollup function and the cube function. First, create a table tmp1 with the following data:

  2022-06-01 13:26:37 Views: 243
• 

  Oracle Health Monitor (Health Monitor)

  Health Monitor (Health Monitor) ORACLE 11G introduces a free database health monitor, which is done through the DBMS_HM package. Check item: 1.DB structural integrity check 2. Data block and integrity check 3. Do log integrity in

  2022-06-01 13:26:37 Views: 289
• 

  Update document (update)

  Modify a simple document: db.getCollection ("test"). Insert ({title: "Commodity Shopping list 1", amount: 35, det

  2022-06-01 13:26:25 Views: 231
• 

  Analysis of DB2 Partition Database

  1. Concept description DB2 database partitioning is provided by the DB2 Enterprise Edition DPF (Data Partitioning Feature) option, which is mainly used to distribute large databases on a partition (logical or physical) to provide the necessary scalability and use the

  2022-06-01 13:26:21 Views: 243
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (10)

  2.3.4 add AG as a cluster resource for SQL Server installation SQL Server resource agent integrated with Pacemaker runs on all nodes: sudo yum install mssql-server-ha create P

  2022-06-01 13:26:18 Views: 287
• 

  MySQL (multi-master and one slave) construction

  Topology diagram: experimental environment: (three virtual machines) server1 (master1-178), server2 (master2-179), server3 (slave-175) Master1: (178) install software yum ins

  2022-06-01 13:25:48 Views: 272
• 

  Memcached usage

  Memcached using 1.1 installation libeventMemcached download address http://memcached.org/downloadsLibevent download address: http://libevent.org

  2022-06-01 13:25:48 Views: 263
• 

  Common table building options and constraints in MySQL

  1. CREATE TABLE option 1. When defining a column, specify column option 1) DEFAULT: define the default value of a column when a new row is inserted into the table and the column is not explicitly assigned, if the default value of the column is defined, the default value is automatically obtained; if not, the default value is automatically obtained

  2022-06-01 13:25:36 Views: 284
• 

  Create table with as and insert into with as statements in oracle

  Oracle supports the use of with as clauses to create table syntax: create table table_name aswith clause_name as (select query) [, clause_nam

  2022-06-01 13:25:23 Views: 228
• 

  Cannot detach database 'xxx because it is currently using a workaround

  The database is used most of the time, if in the process of use, we have to separate the database for some other operations. Then there will be an error like the one shown below. So how to solve this problem? In general, when we operate in the SSMS view, we will close the connected users of SQL. But

  2022-06-01 13:25:23 Views: 291
• 

  Load data local for text import of MySQL

  Data file format: 12345Aeschylus time as he grows old teaches many lessonsAlexander Graham Bell Mr.Watson,come

  2022-06-01 13:25:22 Views: 224
• 

  Basic configuration of redis

  1. Download and install cd / usr/srcwget http://download.redis.io/releases/redis-3.2.3.tar.gztar-xf redis-3.2.3.tar.

  2022-06-01 13:25:19 Views: 248
• 

  Redis 3.0.7 Parameter File referenc

  Cat / app/redis/config/redis_6380.conf # INCLUDES # include / p

  2022-06-01 13:25:19 Views: 230
• 

  & # 160th Oracle control file & # 160

  In Oracle, the control file is the file used when the database is mounted. If the control file is lost or damaged, the instance will crash, in which the parameter file records the location of the control file. After the instance is started to nomount, if the db_names parameter is one of the database names recorded in the control file

  2022-06-01 13:25:19 Views: 215
• 

  [Linux] migrate the Oracle installation directory from the root to the logical volume

  [Linux] migrate the Oracle installation directory from the root directory to logical volume 1.1 BLOG document structure figure 1.2 introduction 1.2.1 introduction and notes for technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other

  2022-06-01 13:25:09 Views: 293
• 

  Error resolution during Oracle 11g installation

  Error report: warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 1e5e0159 solution: rpm-- import / etc/p

  2022-06-01 13:25:08 Views: 240
• 

  One of the expdp and impdp uses (different users and no tablespaces)

  1. Create DIRECTORYSQL > create or replace directory dir_dp as'/ fol/dir_dp';Directory created.2, authorize SQL > gra

  2022-06-01 13:24:55 Views: 272
• 

  Linux Learning: continuous Integration-- introduction and installation of sonarqube Code quality Management platform-04

  1. The official website of SonarQube: https://www.sonarqube.org/SonarQube is an open platform for managing code quality. 1.1 Code quality can be detected from seven dimensions (why use SonarQube)

  2022-06-01 13:24:55 Views: 254
• 

  Mysql erroneous deletion of data-data rollback

  Mysql mistakenly deleted the original Meituan open source Mysql data flashback tool used this time: https://github.com/Meituan-Dianping/MyFlash I, the predecessor of MyFlash is binlong.

  2022-06-01 13:24:28 Views: 235
• 

  Delete Oracle completely under Linux

  1. Stop the Oracle database service shutdown immediate; 2, stop the listening service lsnrctl stop 3, uninstall the database instance with the dbca command 4, delete the three files rm-rf under / usr/local/bin

  2022-06-01 13:24:27 Views: 220