NAV: SLTechnology News&Howtos > Database >

• 

  The method of using decode function or CASE-WHEN to realize custom sorting in Oracle

  This article mainly explains the method of Oracle using decode function or CASE-WHEN to achieve custom sorting, the content is clear, interested friends can learn, I believe it will be helpful after reading. 1 the question sorts the SQL, as long as it is in orde

  2022-06-01 10:02:20 Views: 243
• 

  The method of grabbing red packet function through redis script lua

  This article mainly explains the method of grabbing the red packet function through the redis script lua, the content is clear, interested friends can learn, I believe it will be helpful after reading. The redis script introduces Redis from version 2.6 with built-in support

  2022-06-01 10:02:02 Views: 280
• 

  What needs to be modified to ensure the data independence of the database

  What this article shares with you is about what needs to be modified to ensure the data independence of the database. The editor thinks it is very practical, so I share it with you. I hope you can learn something after reading this article. Let's take a look at it with the editor. In order to ensure the data independence of the database

  2022-06-01 10:02:01 Views: 242
• 

  Oracle- solves connection to server failed, probable Oracle Net admin error

  Solve connection to server failed, probable Oracle Net admin errornavicat for oracle,oracle client software, we are using it to manage

  2022-06-01 10:01:31 Views: 216
• 

  Common problems of left-join in MySQL join table query

  This article mainly explains the common problems of left-join in MySQL join table query, the content is clear, interested friends can learn, I believe it will be helpful after reading it. An overview of small and medium-sized projects, join table query is the most common operation, especially

  2022-06-01 10:01:31 Views: 296
• 

  Install oracle10g release2 under RHEL5.4

  Install oracle10grelease2 environment under RHEL5.4: vmware station10,rhel5.4 system 1, prepare before installation 1, image file of Oracle10g release2 2, install the following rpm package #

  2022-06-01 10:01:31 Views: 272
• 

  The implementation method of descending Index in MySQL8

  This article mainly explains the underlying implementation of the descending index in MySQL8, the content is clear, interested friends can learn, I believe it will be helpful after reading. What is a descending index? you may be familiar with the index, but you are unfamiliar with the descending index. in fact, the descending index

  2022-06-01 10:01:24 Views: 293
• 

  What if MongoDB executes db.dropAllUsers () under the admin library and does not have administrative privileges?

  During the test, the db.dropAllUsers () operation is performed under the amin library, and then all the administrator users are gone, and what action is performed prompts Error: not authorized on admin to execute

  2022-06-01 10:01:24 Views: 285
• 

  Setting up 11g Active Dataguard (ADG)

  Environment: master: IP: 172.18.130.55 DB:11.2.0.1 SID: wsqtestORACLE_BASE: / apps/oracleORACLE_HOME:/apps/oracle/pro

  2022-06-01 10:01:24 Views: 243
• 

  Oracle group by multi-table multi-field association query

  The problem with group by multi-table and multi-field associative query is that it needs the name and quantity of a field at the beginning, but it is the same table. The database code is as follows: select l.batchnumpenol count (l.batchnum)

  2022-06-01 10:01:24 Views: 284
• 

  Troubleshooting of zabbix_server alarms caused by database backup

  Problem: at around 09:15 every day, operators will receive a large number of zabbix_server alarm emails saying "PROBLEM: Zabbix agent on XXX is unreachable for 5 minu"

  2022-06-01 10:01:21 Views: 279
• 

  The difference between undo and redo

  Undo: undo, that is, cancel the previous operation. Redo: redo and perform the previous operation again. What is the REDOREDO record transaction logs, divided into online and archived. For the purpose of recovery. For example, the machine stops.

  2022-06-01 10:01:20 Views: 221
• 

  Sql query II of oracle

  This article is the follow-up to the http://huangsir007.blog.51cto.com/6159353/1854818 film about database language query: SQL > show parameter nls_language

  2022-06-01 10:01:20 Views: 241
• 

  Configure Server Side TAF

  Lab environment: Oracle 11.2.0.4 RAC reference MOS document: How To Configure Server Side Transparent Application Failover (document ID

  2022-06-01 10:01:20 Views: 270
• 

  ELK+Redis log flow presentation

  Business process architecture diagram: a logstash,redis,elasticSearch,kibana-based system architecture diagram for data collection and analysis: log collection system: (data source) logging behavior generated by the producer, through the logsta

  2022-06-01 10:01:12 Views: 229
• 

  PostgreSQL-- several small tip for performance optimization

  1. Reclaim disk space in PostgreSQL, data rows deleted or updated using delete and update statements are not actually deleted, but only set to delete or expire on the physical address of the old version of the data row. So when the data in the data table changes

  2022-06-01 10:01:12 Views: 213
• 

  Common functions of ORACLE

  Classification of the oracle function 1.REPLACE ('string','s1','s2') string wants the character or variable S1 to be replaced string S2 string to be replaced string SQL > select replace (' h

  2022-06-01 10:01:11 Views: 240
• 

  PostgreSQL minor version upgrade

  We know that pg_upgrade and pg_dump/pg_restore can upgrade databases in large versions, so how do small versions upgrade, for example, from 9.6.3 to 9.6.5? Principle: start with a new version of the software program and specify the old data directory to install pgs

  2022-06-01 10:01:11 Views: 255
• 

  Oracle 11G Active DataGuard role switching

  1. Prepare before switching: 1.1.1 main library check: 1.1.1 FAL check SQL > show parameter fal;NAME TYPE VALUE--

  2022-06-01 10:01:11 Views: 249
• 

  How to recover the misoperation of the database?

  SQL Server restores to a certain point in time https://msdn.microsoft.com/zh-cn/library/ms179451.aspx scheduled snapshot https://msdn.micro by backing up files

  2022-06-01 10:01:10 Views: 251