NAV: SLTechnology News&Howtos > Database >

• 

  How to add an index in plsql

  This article will explain in detail how to add an index in plsql. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. An index is a structure that sorts the values of one or more columns in a table, using the

  2022-06-01 11:41:04 Views: 290
• 

  Whether there is a judgment value for redis

  Is there a judgment value for redis? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Redis supports five data types: string (string) hash (ha)

  2022-06-01 11:40:49 Views: 242
• 

  Create trigger

  -- create a trigger--

  2022-06-01 11:40:49 Views: 243
• 

  How to cache redis

  This article uses easy-to-understand examples to introduce how to cache redis, the code is very detailed, interested friends can refer to, hope to be helpful to you. How do I cache redis? First of all, the use of redis needs to be installed in advance on the server, and the installation command is yu

  2022-06-01 11:40:49 Views: 279
• 

  No space is freed after Centos system files are deleted

  Centos system files deleted did not release space today found that a server's / Home directory space is full, Naigos alarm, so to empty useless files, when I deleted files, found that the available space has not changed os:centos5.5 found the current magnetic

  2022-06-01 11:40:48 Views: 231
• 

  Redis of NoSQL (Jedis connection API)

  Project build: (1) introduction: redis can be operated not only with commands, but also with client support in basically mainstream languages, such as java, C, C #, C++, php, Node.js, Go and so on. Jedis is introduced here, address: https:/

  2022-06-01 11:40:48 Views: 209
• 

  Building microservices: how to use mybatis gracefully

  This article is reproduced and released by www.29sl.com: a new project has been launched these two days because the project team members have been using mybatis. Although I prefer the minimalist mode of jpa, I still choose mybatis in order to maintain the unity of the project.

  2022-06-01 11:40:48 Views: 245
• 

  Install MongoDB in Ubuntu 16.0

  MongoDB is a high-performance NoSQL database. Compared with relational database, it has both high performance and high flexibility. Here is how to install and configure MongoDB database on Ubuntu 16.04LTS. Add software source lwk@qw

  2022-06-01 11:40:48 Views: 284
• 

  Make up 12. On the Foreign key constraint of mysql

  First, what is the foreign key in mysql (froeign key) if there are two tables, a field in one table points to the primary key of the other table, which can be called a foreign key (froeign key). When you add a record to a child table, you need to determine whether there is a relationship with the parent

  2022-06-01 11:40:48 Views: 260
• 

  Optimizing it through case study-- the basic concept of Partition Table

  Optimize it through case study-- the basic concept of partition table Introduction to PartitioningPartitioning addresses key issues in supporting very la

  2022-06-01 11:40:41 Views: 233
• 

  Some understanding of JDBC

  JDBC is a kind of java api that executes SQL statements. It is a bridge for java to access databases. It can provide a unified access interface for a variety of relational databases. There are six steps to implementing JDBC (this is connecting to oracle): 1. Register the Driver interface (load a

  2022-06-01 11:40:40 Views: 212
• 

  Centos 6.5Compiler and install LAMP

  Preface 1. Environment description basic environment Linux+Apache+MySQL+PHPlinux:6.5Apache 2.2.12mysql:5.6.17php:5.5.122, deployment description php installation directory: / usr/l

  2022-06-01 11:40:13 Views: 264
• 

  Six common RMAN recovery tests for ORACLE

  In the day-to-day management of ORACLE, backups need to be tested regularly to see if backup files are available. The following is a brief introduction to common recovery scenarios. 1. Preparation before backup 1. Check the location of the parameter file SQL > show parameter spfi

  2022-06-01 11:40:03 Views: 284
• 

  Solve the problem of database downtime independently

  1. If a database is found to be down, (ps-ef | grep smon) first consider whether it is RAC and whether it affects the normal generation environment. Determine the approximate repair time. If it is RAC, enter the action command on another database. Find the static parameter file to start

  2022-06-01 11:40:03 Views: 291
• 

  Deployment and Application of LNMP platform

  LAMP platform should be the most widely used web server architecture at present, but with the increasing use of Nginx in enterprises, LNMP (or LEMP) architecture is favored by more and more Linux system engineers, in which "E" comes from the pronunciation of Nginx [eng].

  2022-06-01 11:40:03 Views: 230
• 

  CentOS7LAMP deployment proc

  (1) configuration summary: 1. 172.18.17.7 host runs httpd+php service (php is module working mode) to configure two virtual hosts: wordpress personal blog system, PHPmyadmin remote control mysql2, 172.1

  2022-06-01 11:39:48 Views: 297
• 

  Bit by bit of learning shell+sql

  For meaningless scripts, don't spray / [root@test Desktop] # vim oraclesh.sh #! / bin/bashclear# function test_parameter1 () {`echo `script-or

  2022-06-01 11:39:47 Views: 214
• 

  A preliminary understanding of the open source framework Druid for database connection pooling

  Druid is an open source framework of Alibaba's database connection pooling. To be exact, it not only includes database connection pooling, but also provides powerful monitoring and expansion functions. This article is only a snoop on Druid without Spring framework, using the latest version of druid

  2022-06-01 11:39:37 Views: 296
• 

  Detailed introduction, installation and deployment of hive

  Introduction: first, what is hive??? 1 Hadoop-based data warehouse tool, 2, can map structured data files to a database table, and provide sql-like query function, 3, can convert sql statements into mapreduce tasks

  2022-06-01 11:39:35 Views: 290
• 

  MongoDB Replica Set building

  Part 0 Business Information Business name: xyz port number: 28017 part 1 prepare environment creation mongodb user # useradd mongodb create data directory # mkdir-pv / data1/mongodb/28

  2022-06-01 11:39:31 Views: 229